You are here: Supported SQL
ContentsIndexHome
PreviousUpNext
Supported SQL

This SQL parser is updated quickly, so the best way to check whether a sql is supported is to write a simple application with parse function to check it. 

 

 

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 ] 

[ { TOP integer | TOP integer PERCENT } [ WITH TIES ] ] 

target_list 

FROM table_ref [, table_ref]... 

[ WHERE condition ] 

[ group_by_clause ] 

[ HAVING condition ] 

[ { UNION | UNION ALL | INTERSECT | MINUS } ( subquery )] 

[ order_by_clause ] 

[LIMIT { number | ALL }] [OFFSET number] 

[ 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.

 

MySQL stored procedure.

 

DB2 stored procedure.
Gudu software http://www.sqlparser.com
Send comments about this topic.