General SQL Parser -> Supported SQL

Supported SQL

Data type:
	character: char,varchar2,nchar,nvarchar2
	Number: number, integer,int,small,float,double,real,numberic,decimal,dec
	Datetime: date, timestamp, interval year to month, interval day to second
	Long and raw : long, long raw , raw
	Large object: blob, clob, nclob,bfile
	Rowid: rowid, urowid

Expression:
	Math Operator: + - * / 
	Concatenation operator: ||
	Supported function: case, decode
	Logical operator: and, or, not, is [not] null, [not] in , between, 
		         exists,like, = , != , <>, >,<, >=, =<, any ,some, all

Select:
	SELECT [ hint ] [ { DISTINCT | UNIQUE } | ALL ] target_list 
	[ into clause ]
	FROM table_ref [, table_ref]... 
	[ WHERE condition ]
	[ group_by_clause ]
	[ HAVING condition ]  
	[ { UNION | UNION ALL | INTERSECT | MINUS } ( subquery )] 
	[ order_by_clause ]
	[ for_update_clause ];

Insert:
	INSERT_INTO {table_reference | (subquery)}
	[(column_name [, column_name]...)]
	{VALUES (sql_expression [, sql_expression]...) | (subquery)}

Update:
	UPDATE {table_reference | (subquery)} [alias]
	SET 
	{column_name = {sql_expression | (subquery)}
	|(column_name [, column_name]...) = (subquery)} 
	[, {column_name = {sql_expression | (subquery)}
	|(column_name [, column_name]...) = (subquery)}]...
	[WHERE search_condition]

Delete:
	DELETE [FROM] {table_reference | (subquery)} [alias]
	[WHERE {search_condition }];

Create table:
	CREATE [GLOBAL TEMPORARY] TABLE [schema .] table 
	( column datatype [DEFAULT expr] 
		[ inline_constraint [inline_constraint]... ] | [out_of_line_constraintt ]
	[, column datatype [DEFAULT expr] 
		[ inline_constraint [inline_constraint]... ] | [out_of_line_constraintt ]
	]...

   inline_constraint:
	[CONSTRAINT constraint_name]
	{ [NOT] NULL
	| UNIQUE
	| PRIMARY KEY
	| references_clause
	| CHECK ( condition )
	} [constraint_state]

   out_of_line_constraint:
	[CONSTRAINT constraint_name]
	{ UNIQUE ( column [, column]... )
	| PRIMARY KEY ( column [, column]...  
	| FOREIGN KEY ( column [, column]...   references_clause
	| CHECK ( condition )
	} [constraint_state]

Create Index:
	CREATE [ UNIQUE | BITMAP ] INDEX [schema .] index ON
	[schema .] table [t_alias] 
	( index_expr [ ASC | DESC ] [, index_expr [ ASC | DESC ]]... )

Create View:
	CREATE [OR REPLACE] [[NO] FORCE] VIEW [schema .] view
	AS subquery [subquery_restriction_clause];

   subquery_restriction_clause:
	WITH { READ ONLY | CHECK OPTION [CONSTRAINT constraint] }

Drop table:
	DROP TABLE [schema .] table [CASCADE CONSTRAINTS];

Drop Index:
	DROP INDEX [schema .] index [FORCE];

Drop View:
	DROP VIEW [schema .] view [CASCADE CONSTRAINTS];