General SQL Parser: sql engine for various databases

Supported SQL

This page only lists some SQL syntax supported by General SQL Parser, the best way to check
all SQL syntax supported by this parser is download and test it yourself.

Detailed sql statements support list: oracle, sql server, DB2, MySQL


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];

Oracle PL/SQL

MSSQL procedure and function.