Occasionally, I come across a large multi-line SQL block inside Java code. The following sed one liner takes the code off fro
[[Category:Java]] [[Category:Sql]] [[Category:Unix]]
...
412 bytes (65 words) - 02:00, 12 December 2008
...re ignored. The DBMS_OUTPUT package is especially useful for displaying PL/SQL debugging information.
...
1 KB (210 words) - 01:56, 24 June 2009
The theta join is probably the least used SQL join type. Here's an example of a theta join in use. Lets say you have a
<geshi lang="sql">
...
613 bytes (103 words) - 04:55, 4 January 2010
== SQL ==
...
3 KB (565 words) - 21:12, 17 May 2010
sql = "create database IF NOT EXISTS #{v['database']}; grant all on #{v['databa
`mysql -u root -e "#{sql}"`
...
3 KB (427 words) - 17:50, 17 August 2006
Reorg command failed: SQL2216N SQL error "-291" occurred while reorganizing a database table or its indexes.
...
2 KB (255 words) - 17:46, 13 August 2012
(SQL query hidden) (SQL query hidden)
<syntaxhighlight lang="sql">
...
8 KB (1,312 words) - 22:56, 10 December 2011
Server Service: SQL Server
...
3 KB (497 words) - 22:08, 23 February 2009
<syntaxhighlight lang="sql">
..., but it's easy to put in place. Here's a Ruby script which generates the SQL for a list of tables.
...
6 KB (871 words) - 15:01, 3 July 2014