This table lists how oracle sql dialect was supported by general sql parser.
There are two supporting levels accroding to how general sql parser handle that sql.
Level 1 stands for this sql can be handled by GetRawSqlStatements function
Level 2 stands for this sql can be handled by Parse function
| All
sqls |
Level 1 |
Level 2 |
| alter
cluster |
Y |
|
| alter
database |
Y |
|
| alter
dimension |
Y |
|
| alter
diskgroup |
Y |
|
| alter
function |
Y |
|
| alter
index |
Y |
|
| alter
indextype |
Y |
|
| alter
java |
Y |
|
| alter
materialized view |
Y |
|
| alter
materialized view log |
Y |
|
| alter
operator |
Y |
|
| alter
outline |
Y |
|
| alter
package |
Y |
|
| alter
procedure |
Y |
|
| alter
profile |
Y |
|
| alter
resource cost |
Y |
|
| alter
role |
Y |
|
| alter
rollback segment |
Y |
|
| alter
sequence |
Y |
|
| alter
session |
Y |
|
| alter
system |
Y |
|
| alter
table |
Y |
Y |
| alter
tablespace |
Y |
|
| alter
trigger |
Y |
|
| alter
type |
Y |
|
| alter
user |
Y |
|
| alter
view |
Y |
|
| analyze |
Y |
|
| associate
statistics |
Y |
|
| audit |
Y |
|
| call |
Y |
|
| comment |
Y |
Y |
| commit |
Y |
|
| create
cluster |
Y |
|
| create
context |
Y |
|
| create
controlfile |
Y |
|
| create
database |
Y |
|
| create
database link |
Y |
|
| create
dimension |
Y |
|
| create
directory |
Y |
|
| create
diskgroup |
Y |
|
| create
function |
Y |
Y |
| create
index |
Y |
Y |
| create
indextype |
Y |
|
| create
java |
Y |
|
| create
library |
Y |
|
| create
materialized view |
Y |
|
| create
materialized view log |
Y |
|
| create
operator |
Y |
|
| create
outline |
Y |
|
| create
package |
Y |
Y |
| create
package body |
Y |
Y |
| create
pfile |
Y |
|
| create
procedure |
Y |
Y |
| create
profile |
Y |
|
| create
restore point |
Y |
|
| create
role |
Y |
|
| create
rollback segment |
Y |
|
| create
schema |
Y |
|
| create
sequence |
Y |
Y |
| create
spfile |
Y |
|
| create
synonym |
Y |
|
| create
table |
Y |
Y |
| create
tablespace |
Y |
|
| create
trigger |
Y |
Y |
| create
type |
Y |
Y |
| create
type body |
Y |
Y |
| create
user |
Y |
|
| create
view |
Y |
Y |
| delete |
Y |
Y |
| disassociate
statistics |
Y |
|
| drop
cluster |
Y |
|
| drop
context |
Y |
|
| drop
database |
Y |
|
| drop
database link |
Y |
|
| drop
dimension |
Y |
|
| drop
directory |
Y |
|
| drop
diskgroup |
Y |
|
| drop
function |
Y |
|
| drop
index |
Y |
Y |
| drop
indextype |
Y |
|
| drop java |
Y |
|
| drop
library |
Y |
|
| drop
materialized view |
Y |
|
| drop
materialized view log |
Y |
|
| drop
operator |
Y |
|
| drop
outline |
Y |
|
| drop
package |
Y |
|
| drop
procedure |
Y |
|
| drop
profile |
Y |
|
| drop
restore point |
Y |
|
| drop role |
Y |
|
| drop
rollback segment |
Y |
|
| drop
sequence |
Y |
|
| drop
synonym |
Y |
|
| drop
table |
Y |
Y |
| drop
tablespace |
Y |
|
| drop
trigger |
Y |
|
| drop type |
Y |
|
| drop type
body |
Y |
|
| drop user |
Y |
|
| drop view |
Y |
Y |
| explain
plan |
N |
|
| flashback
database |
N |
|
| flashback
table |
N |
|
| grant |
Y |
|
| insert |
Y |
Y |
| lock
table |
Y |
|
| merge |
Y |
Y |
| noaudit |
Y |
|
| purge |
Y |
|
| rename |
Y |
|
| revoke |
Y |
|
| rollback |
Y |
|
| savepoint |
Y |
|
| select |
Y |
Y |
| set
constraints |
Y |
|
| set role |
Y |
|
| set
transaction |
Y |
|
| truncate |
Y |
|
| update |
Y |
Y |
|
|
|