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.
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.
COPYRIGHT (C) 2001-2008 sqlparser.com , privacy policy ALL RIGHT RESERVED
|