HOWTO - SQL92 Syntax

	CHAR(n) | CHARACTER(n)
	VARCHAR(n) | CHARACTER VARYING(n) | <VARCHAR2(n)>
	INTEGER | INT | SMALLINT
	DECIMAL(p,s) | DEC(p,s) | NUMERIC(p,s)
	FLOAT(p) | REAL | DOUBLE PRECISION
	DATE | TIME
	INTERVAL year-month | INTERVAL day
	BOOLEAN | BLOB

	< > <= >= <> =			AND OR NOT
	IS [NOT] NULL			[NOT] LIKE
	[NOT] IN ( [,...] )		[NOT] BETWEEN x AND y
	[conditional] ANY ( [,...] )
	[conditional] ALL ( [,...] )

	AVG | MAX | MIN | SUM | COUNT
	GREATEST|LEAST(x,y,...)
	<{ROUND|TRUNC<!ATE>}({x,places|date,format})>
	POSITION( s1 IN s2)
	EXTRACT( datetime FROM datetime_value)
	CHAR_LENGTH( s1 ) <LENGTH( s1 )>
	SUBSTRING(string FROM start [FOR length])|<SUBSTR(string,start,length)>
	<INSTR(str,substr,start,mnth)>
	{<INITCAP>|UPPER|LOWER}(string)
	TRIM({BOTH|LEADING|TRAILING} char FROM string)|<{L|R}TRIM(str,chrset)>
	{TRANSLATE|CONVERT}( char USING value) |<TRANSLATE(str,from,to)>
	<{L|R}PAD(str,to_len,str2)>
	<DECODE(expr,search1,result1,...[,default])>
	<NVL(expr,replace)>

	SYYYY|YYYY|YEAR|SYEAR|YY|IYYY|RR|RRRR		MONTH|MON|MM|RM
	DDD|DD|J	DAY|DY|D	HH|HH12|HH24	MI	SS|SSSSS
	IW  AM|PM  BC Q WW(year week) W (month week)

	ALTER TABLE table [ * ]
	    ADD [<!COLUMN>] column type
	ALTER TABLE table [ * ]
	    DROP [ COLUMN ] column
	ALTER TABLE table [ * ]
	    MODIFY [<!COLUMN>] column { <!SET> DEFAULT value | DROP DEFAULT }
	ALTER TABLE table [ * ]
	    MODIFY [<!COLUMN>] column column_constraint
	ALTER TABLE table [ * ]
	    RENAME [<!COLUMN>] column TO newcolumn
	ALTER TABLE table
	    RENAME TO newtable
	ALTER TABLE table
	    ADD table_constraint
	ALTER TABLE table
	    {ENABLE|DISABLE} {NO}VALIDATE CONSTRAINT constraint

	ALTER USER username IDENTIFIED BY passwd

	CREATE <![TEMPORARY|TEMP]> TABLE table (
	    column type
	    [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
	    [column_constraint_clause | PRIMARY KEY } [ ... ] ]
	    [, ... ]
	    [, PRIMARY KEY ( column [, ...] ) ]
	    [, CHECK ( condition ) ]
	    [, table constraint ]
	    )
	<CREATE TABLE table AS select query>

	CREATE TRIGGER name { BEFORE | AFTER |INSTEAD OF}
	    {DELETE| INSERT | UPDATE [OF (col,...)] [OR ...] }
	    ON {table|view} FOR EACH { ROW | STATEMENT }
	    [ WHEN (condition) ]
	    [<!EXECUTE PROCEDURE func ( arguments )>| pl/sql block]

	CREATE SEQUENCE seqname [ INCREMENT BY increment ]
	    [ MINVALUE minvalue ] [ MAXVALUE maxvalue ]
	    [ START start ] [ CACHE cache | <WITH> NOCACHE ] [ CYCLE ]

	(use seqname.CURRVAL & seqname.NEXTVAL)

	CREATE [UNIQUE|<BITMAP>] INDEX index_name ON table
	    [<!USING acc_name>] ( column [ASC|DESC][,...]) [NOSORT|REVERSE]
	CREATE [ UNIQUE ] INDEX index_name ON table
	    [ USING acc_name ] ( func_name( column [, ... ]) [ ops_name ] )

	CREATE VIEW view AS select query
	ALTER VIEW view COMPILE

	CREATE SYNONYM synname FOR object

	COMMENT ON TABLE table IS 'string'
	COMMENT ON COLUMN table.col IS 'string'

	TRUNCATE TABLE table

	RENAME table TO newtable

	DROP TABLE name [,...] <CASCADE CONSTRAINTS>
	DROP VIEW name
	DROP SEQUENCE name [,...]
	...

	INSERT INTO table [ ( column [, ...] ) ]
	    { VALUES ( expression [, ...] ) | SELECT query }

	UPDATE table SET col = expression [,...]
	    [ FROM fromlist ]
	    [ WHERE condition ]

	DELETE FROM table [ WHERE condition ]

	SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
	    expression [ <![AS]> name ] [,...]
	    [ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ]
	    [ FROM {table | (select query)} [ alias ] [,...] ]
	    [ {{LEFT | RIGHT} [OUTER] | NATURAL |[FULL] OUTER} JOIN table alias
		{ON condition | USING(col1,col2,...)} ]
	    [ WHERE {condition | EXISTS (correlated subquery)} ]
	    [ GROUP BY column [,...] ]
	    [ HAVING condition [,...] ]
	    [ { UNION [ ALL ] | INTERSECT | EXCEPT | MINUS } select ]
	    [ ORDER BY {column | int} [ ASC | DESC | USING operator ] [,...] ]
	    [ FOR UPDATE [ OF class_name [,...] ] ]
	    LIMIT { count | ALL } [ { OFFSET | ,} start ]

	DECLARE cursorname [ BINARY ] [ INSENSITIVE ] [ SCROLL ]
	    CURSOR FOR query
	    [ FOR { READ ONLY | UPDATE [ OF column [,...] ] ]

	FETCH [ selector ] [ count ] { IN | FROM } cursor
	FETCH [ RELATIVE ] [{ [ # | ALL | NEXT | PRIOR ] }] FROM cursor

	CLOSE cursor