jingshanglu opened a new issue, #6480: URL: https://github.com/apache/shardingsphere/issues/6480
Hi community, This issue is to collate the SQL definitions of Oracle. **Therefore, we can support parsing more SQLs**. We need your interaction! If you > 1. Be familiar with `g4 file` of Antlr (The grammars are RegularExpression-like) > 2. Understand the `Oracle grammars` then welcome! ### Background **How is a SQL parsed?** `SQL definition file` ->(Parse to) `AST` ->(Visit it) `SQLStatment` ### Process 1. Compare `SQL definitions` in [Oficial SQL Doc](https://docs.oracle.com/en/database/oracle/oracle-database/18/lnpls/plsql-language-elements.html#GUID-285DFAEE-1A34-4248-BA4B-2591476A0C3C) and [ShardingSphere SQL Doc](https://github.com/apache/shardingsphere/tree/master/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-oracle/src/main/antlr4/imports/oracle) 2. If there is any difference in ShardingSphere SQL Doc, please correct them referring to Official SQL Doc 3. Run `mvn install the current_file_module` 4. Check whether there are any exceptions. If indeed, please fix them. (Especially `xxxVisitor.class`) 5. Add new corresponding SQL case in [SQL Cases](https://github.com/apache/shardingsphere/tree/master/shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/test/resources/sql/supported) and expected parsed result in [Expected Statment XML](https://github.com/apache/shardingsphere/tree/master/shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/resources/case) 6. Run [SQLParserParameterizedTest](https://github.com/apache/shardingsphere/blob/master/shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/engine/SQLParserParameterizedTest.java) to make sure no exceptions. ### Notice 1.`Left recursion` can not work well in Antlr4, ``` a : b | a b ; b : a c ; c : ... ; ``` you can consider the following one, ``` a : b* ; b : a c ; c : ... ; ``` 2. [Here](https://shimo.im/docs/WrgrCt9JR3JDjq8H/read) is a Chinese version for reference. ### subtask #### DML - [x] call [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CALL.html#GUID-6CD7B9C4-E5DC-4F3C-9B6A-876AD2C63545) - [x] delete [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DELETE.html#GUID-156845A5-B626-412B-9F95-8869B988ABD7) - [ ] EXPLAIN PLAN [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/EXPLAIN-PLAN.html#GUID-FD540872-4ED3-4936-96A2-362539931BA0) - [x] insert [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/INSERT.html#GUID-903F8043-0254-4EE9-ACC1-CB8AC0AF3423) - [ ] LOCK TABLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/LOCK-TABLE.html#GUID-4C00C6D9-C5C5-46CC-AD33-A64001744A4C) - [x] merge [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/MERGE.html#GUID-5692CCB7-24D9-4C0E-81A7-A22436DC968F) - [x] select [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6) - [x] update [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/UPDATE.html#GUID-027A462D-379D-4E35-8611-410F3AC8FDA5) #### DDL-ALTER - [ ] ALTER ANALYTIC VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-ANALYTIC-VIEW.html#GUID-5256BE3A-F134-40D4-8E70-684E073574C8) - [ ] ALTER ATTRIBUTE DIMENSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-ATTRIBUTE-DIMENSION.html#GUID-F345D0F9-8133-4257-9A07-EDCE558A1332) - [ ] ALTER AUDIT POLICY (Unified Auditing) [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-AUDIT-POLICY-Unified-Auditing.html#GUID-CC41B5C2-09F4-40BC-B7FD-3B4C0A3F5437) - [ ] ALTER CLUSTER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-CLUSTER.html#GUID-A4E03C13-7690-4567-9B0A-DA6A21173B4D) - [ ] ALTER DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DATABASE.html#GUID-8069872F-E680-4511-ADD8-A4E30AF67986) - [ ] ALTER DATABASE DICTIONARY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DATABASE-DICTIONARY.html#GUID-27DDB403-7E7F-40EC-9B48-5E3B475E27AE) - [ ] ALTER DATABASE LINK [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DATABASE-LINK.html#GUID-0259D771-9D04-4D86-A94D-61B621A3918A) - [x] ALTER DIMENSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DIMENSION.html#GUID-16B451F9-FF21-4E44-ACCA-2CFFA6F3F0F9) - [ ] ALTER DISKGROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DISKGROUP.html#GUID-22D73AB6-7063-4627-A2ED-18D521ED2557) - [ ] ALTER FLASHBACK ARCHIVE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-FLASHBACK-ARCHIVE.html#GUID-285814C9-06ED-4BDB-BB19-E2BA6505C850) - [ ] ALTER FUNCTION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-FUNCTION.html#GUID-6FB32876-2DB3-41EB-B0CA-91B163826AB2) - [ ] ALTER HIERARCHY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-HIERARCHY.html#GUID-37A4E442-EE3A-4239-8228-F08A2F666D91) - [x] ALTER INDEX [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-INDEX.html#GUID-D8F648E7-8C07-4C89-BB71-862512536558) - [ ] ALTER INDEXTYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-INDEXTYPE.html#GUID-BFA7E29C-7905-4811-9119-B20FD8EA18F2) - [ ] ALTER INMEMORY JOIN GROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-INMEMORY-JOIN-GROUP.html#GUID-AF24F413-BB14-4B5D-93BF-9EB31ACFEBEC) - [ ] ALTER JAVA [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-JAVA.html#GUID-6B211750-3247-4D71-9533-3DD8F66640CD) - [ ] ALTER LIBRARY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-LIBRARY.html#GUID-BB90AF66-3B1F-46C4-9716-4578DE0AE1F3) - [ ] ALTER LOCKDOWN PROFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-LOCKDOWN-PROFILE.html#GUID-B4029154-54A8-4B78-97C3-9CED416F1C34) - [ ] ALTER MATERIALIZED VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-MATERIALIZED-VIEW.html#GUID-29EE5682-AE42-4879-ABAD-E34E66ADD233) - [ ] ALTER MATERIALIZED VIEW LOG [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-MATERIALIZED-VIEW-LOG.html#GUID-4DAD5E6F-E30A-43D0-B023-634752E0E627) - [ ] ALTER MATERIALIZED ZONEMAP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-MATERIALIZED-ZONEMAP.html#GUID-9330FD16-28B6-4B22-8205-FF59AF250C1A) - [ ] ALTER OPERATOR [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-OPERATOR.html#GUID-F00A0AC8-36C8-4EAC-A9BB-B3D42C5EEEDE) - [ ] ALTER OUTLINE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-OUTLINE.html#GUID-49F25C82-0783-4407-88BB-613F986C2FEC) - [ ] ALTER PACKAGE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-PACKAGE.html#GUID-47471C4C-03AB-4D78-A295-3D58C91102E0) - [ ] ALTER PLUGGABLE DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-PLUGGABLE-DATABASE.html#GUID-A29491AD-8F0F-4E52-9D94-57FC3FF8FBC7) - [ ] ALTER PROCEDURE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-PROCEDURE.html#GUID-24A5796F-7D97-49D4-8448-7E541CB73AC6) - [ ] ALTER PROFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-PROFILE.html#GUID-7D2EA18A-49F9-40FA-ADE8-BB3D5D5FE4A1) - [ ] ALTER RESOURCE COST [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-RESOURCE-COST.html#GUID-92DCB41E-5113-4722-8A54-E90E1AE7DB54) - [ ] ALTER ROLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-ROLE.html#GUID-85543272-EAF4-4FED-A921-AD9868102C39) - [ ] ALTER ROLLBACK SEGMENT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-ROLLBACK-SEGMENT.html#GUID-B25701E3-A074-44C4-9018-C6691BEB2483) - [ ] ALTER SEQUENCE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-SEQUENCE.html#GUID-A6468B63-E7C9-4EF0-B048-82FE2449B26D) - [x] ALTER SYNONYM [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-SYNONYM.html#GUID-C31B6804-6783-4A8C-B448-DF78E3FE6837) - [ ] ALTER TABLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9386F2877) - [ ] ALTER TABLESPACE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-TABLESPACE.html#GUID-CA074861-55D3-4768-8995-43D4DA26365D) - [ ] ALTER TABLESPACE SET [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-TABLESPACE-SET.html#GUID-63FEDE73-C1F1-4B7A-98ED-8C34C4073549) - [x] ALTER TRIGGER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-TRIGGER.html#GUID-085BD628-2903-46A3-9850-C0D8ED7F2EEF) - [ ] ALTER TYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-TYPE.html#GUID-E0C4E28C-726F-4481-99FE-15AC67342DC9) - [ ] ALTER USER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-USER.html#GUID-9FCD038D-8193-4241-85CD-2F4723B27D44) - [x] ALTER VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-VIEW.html#GUID-0DEDE960-B481-4B55-8027-EA9E4C863625) #### DDL-CREATE - [ ] CREATE ANALYTIC VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-ANALYTIC-VIEW.html#GUID-EBA7E9BC-3F49-4AA7-9EF6-9255FE7AE466) - [ ] CREATE ATTRIBUTE DIMENSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-ATTRIBUTE-DIMENSION.html#GUID-62722AB0-2136-4BC9-8E76-CBEA13C15196) - [ ] CREATE AUDIT POLICY (Unified Auditing) [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-AUDIT-POLICY-Unified-Auditing.html#GUID-8D6961FB-2E50-46F5-81F7-9AEA314FC693) - [ ] CREATE CLUSTER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-CLUSTER.html#GUID-4DBC701F-AFC3-486D-AA32-B5CB1D6946F7) - [ ] CREATE CONTEXT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-CONTEXT.html#GUID-FDF62812-A884-479C-9C1B-5BD6DDEFE7FA) - [ ] CREATE CONTROLFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-CONTROLFILE.html#GUID-9B389F28-C4D0-405D-BFE6-48237E8BD791) - [x] CREATE DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DATABASE.html#GUID-ECE717DF-F116-4151-927C-2E51BB9DD39C) - [x] CREATE DATABASE LINK [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DATABASE-LINK.html#GUID-D966642A-B19E-449D-9968-1121AF06D793) - [x] CREATE DIMENSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DIMENSION.html#GUID-E6CD4CFC-5D06-4A8F-9DF1-C609A7EB8413) - [ ] CREATE DIRECTORY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DIRECTORY.html#GUID-8E9C569A-1B06-42C4-9586-0EF83437001A) - [ ] CREATE DISKGROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DISKGROUP.html#GUID-039A1373-1F3F-4A53-A152-8EBC348FB880) - [x] CREATE EDITION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-EDITION.html#GUID-6CF92CA1-CAF7-4967-9B34-C02D72C23617) - [ ] CREATE FLASHBACK ARCHIVE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-FLASHBACK-ARCHIVE.html#GUID-9E821EC5-8350-4729-85FE-2188EBB4139B) - [ ] CREATE FUNCTION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-FUNCTION.html#GUID-156AEDAC-ADD0-4E46-AA56-6D1F7CA63306) - [ ] CREATE HIERARCHY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-HIERARCHY.html#GUID-73925877-992B-4624-AA28-8F565E9C3F0D) - [x] CREATE INDEX [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-INDEX.html#GUID-1F89BBC0-825F-4215-AF71-7588E31D8BFE) - [ ] CREATE INDEXTYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-INDEXTYPE.html#GUID-4A7BD0EC-B3E5-4D1D-95C5-C8B52D01D8CE) - [ ] CREATE INMEMORY JOIN GROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-INMEMORY-JOIN-GROUP.html#GUID-87CA7034-4F80-4D46-8EE1-5CC865C2D676) - [ ] CREATE JAVA [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-JAVA.html#GUID-69E13452-1F91-4F98-B154-CF5B1C198387) - [ ] CREATE LIBRARY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-LIBRARY.html#GUID-F042ABC9-2BF5-4E65-9D52-216D6228B288) - [ ] CREATE LOCKDOWN PROFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-LOCKDOWN-PROFILE.html#GUID-1CDEC3A3-F3F1-4279-9370-36AACF416E0A) - [ ] CREATE MATERIALIZED VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-MATERIALIZED-VIEW.html#GUID-EE262CA4-01E5-4618-B659-6165D993CA1B) - [ ] CREATE MATERIALIZED VIEW LOG [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-MATERIALIZED-VIEW-LOG.html#GUID-13902019-D044-4B79-9EB4-1F60652D037B) - [ ] CREATE MATERIALIZED ZONEMAP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-MATERIALIZED-ZONEMAP.html#GUID-1E5048FC-3D28-49BC-80FE-7871568B4702) - [ ] CREATE OPERATOR [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-OPERATOR.html#GUID-62676C58-6F57-4572-8C09-7984A8E3EE9F) - [ ] CREATE OUTLINE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-OUTLINE.html#GUID-7CC033AF-DB19-4616-87D9-8173939FD627) - [ ] CREATE PACKAGE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PACKAGE.html#GUID-40636655-899F-47D0-95CA-D58A71C94A56) - [ ] CREATE PACKAGE BODY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PACKAGE-BODY.html#GUID-E571E5A3-1C4B-4246-BF26-0E4348BEB6D6) - [ ] CREATE PFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PFILE.html#GUID-C01CBA1C-F477-49BE-AD58-F2FED046D561) - [ ] CREATE PLUGGABLE DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC) - [ ] CREATE PROCEDURE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PROCEDURE.html#GUID-771879D8-BBFD-4D87-8A6C-290102142DA3) - [ ] CREATE PROFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PROFILE.html#GUID-ABC7AE4D-64A8-4EA9-857D-BEF7300B64C3) - [ ] CREATE RESTORE POINT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-RESTORE-POINT.html#GUID-AD0FB693-7C28-4908-A870-BA884B320575) - [ ] CREATE ROLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-ROLE.html#GUID-B2252DC5-5AE7-49B7-9048-98062993E450) - [ ] CREATE ROLLBACK SEGMENT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-ROLLBACK-SEGMENT.html#GUID-14AE3104-5B33-4E53-8E6F-6B2F037B52E9) - [ ] CREATE SCHEMA [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SCHEMA.html#GUID-2D154F9C-9E2B-4A09-B658-2EA5B99AC838) - [ ] CREATE SEQUENCE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SEQUENCE.html#GUID-E9C78A8C-615A-4757-B2A8-5E6EFB130571) - [ ] CREATE SPFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SPFILE.html#GUID-D3E295B7-A3A4-43D3-8BBD-5CBE171A2E52) - [ ] CREATE SYNONYM [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SYNONYM.html#GUID-A806C82F-1171-478E-A910-F9C6C42739B2) - [x] CREATE TABLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6) - [ ] CREATE TABLESPACE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLESPACE.html#GUID-51F07BF5-EFAF-4910-9040-C473B86A8BF9) - [ ] CREATE TABLESPACE SET [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLESPACE-SET.html#GUID-877951F1-B2A5-4907-9F0F-EF4F1884E8C4) - [ ] CREATE TRIGGER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TRIGGER.html#GUID-EE0DF3AA-7ADC-4171-B8E8-138BE9224E3B) - [ ] CREATE TYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TYPE.html#GUID-E72E3EE6-DE95-4F58-8941-E2F76D0EAE80) - [ ] CREATE TYPE BODY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TYPE-BODY.html#GUID-C4F1591A-6F62-4897-9039-2C3F066F1E9D) - [ ] CREATE USER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-USER.html#GUID-F0246961-558F-480B-AC0F-14B50134621C) - [ ] CREATE VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-VIEW.html#GUID-61D2D2B4-DACC-4C7C-89EB-7E50D9594D30) #### DDL-DROP - [ ] DROP ANALYTIC VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-ANALYTIC-VIEW.html#GUID-16BF7588-87E8-4324-BCEC-242355245720) - [ ] DROP ATTRIBUTE DIMENSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-ATTRIBUTE-DIMENSION.html#GUID-98D6273D-5F83-4AEC-85AF-7540A710F59D) - [ ] DROP AUDIT POLICY (Unified Auditing) [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-AUDIT-POLICY-Unified-Auditing.html#GUID-811D3F84-744E-47A1-B69D-C9D2FA4A0844) - [ ] DROP CLUSTER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-CLUSTER.html#GUID-531F7DE2-AA2A-400E-BC9A-4CBEEA7B7156) - [ ] DROP CONTEXT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-CONTEXT.html#GUID-1C5C56A8-A3A3-421B-BEC5-C6ECCA0B60D0) - [ ] DROP DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DATABASE.html#GUID-4FFC1AF5-538D-4882-8979-7A9957492A23) - [x] DROP DATABASE LINK [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DATABASE-LINK.html#GUID-89856C55-29FB-4B52-84A9-E53B8D115864) - [x] DROP DIMENSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DIMENSION.html#GUID-658FB451-6759-4777-ACDB-614CFDEFDF80) - [x] DROP DIRECTORY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DIRECTORY.html#GUID-3719950A-7B6A-4284-8467-B3455ECF8516) - [ ] DROP DISKGROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DISKGROUP.html#GUID-6F77FABB-3365-448F-8E2B-9B776904182C) - [ ] DROP EDITION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-EDITION.html#GUID-726082F7-C931-4975-8F2B-5EA814A51AB0) - [ ] DROP FLASHBACK ARCHIVE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-FLASHBACK-ARCHIVE.html#GUID-FFF61E62-28AF-4F7B-BBD7-8D9AC08DDE77) - [ ] DROP FUNCTION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-FUNCTION.html#GUID-5BF63D1C-797E-4FB7-BEAB-B02BD7AADAEF) - [ ] DROP HIERARCHY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-HIERARCHY.html#GUID-03DD165D-EDCC-484F-B79B-D56447587669) - [x] DROP INDEX [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-INDEX.html#GUID-F60F75DF-2866-4F93-BB7F-8FCE64BF67B6) - [ ] DROP INDEXTYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-INDEXTYPE.html#GUID-36D05D07-72C4-48F9-B27D-7C4BBD2C1A81) - [ ] DROP INMEMORY JOIN GROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-INMEMORY-JOIN-GROUP.html#GUID-520D0E9A-B577-4BCD-B6CB-8EB448C0686D) - [ ] DROP JAVA [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-JAVA.html#GUID-0D24ADCD-01C8-4FB0-B14C-F5D9FB25E321) - [ ] DROP LIBRARY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-LIBRARY.html#GUID-82F45872-78AD-4125-8D14-EE6A69E2738D) - [ ] DROP LOCKDOWN PROFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-LOCKDOWN-PROFILE.html#GUID-62D428C1-5081-43CA-B45D-7FF1B81363E7) - [ ] DROP MATERIALIZED VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-MATERIALIZED-VIEW.html#GUID-187B88E0-F84A-44DB-8F4D-F477586FD22B) - [ ] DROP MATERIALIZED VIEW LOG [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-MATERIALIZED-VIEW-LOG.html#GUID-878A08F7-CB95-4911-BE2E-9FEED8861410) - [ ] DROP MATERIALIZED ZONEMAP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-MATERIALIZED-ZONEMAP.html#GUID-818B228D-9849-4C0C-944E-7A8DEF04A2D0) - [ ] DROP OPERATOR [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-OPERATOR.html#GUID-48E60BB4-9490-4B8B-B08E-D17EAEBDDD7E) - [ ] DROP OUTLINE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-OUTLINE.html#GUID-776F36E0-1905-48DC-9062-FBFAD5E1C36F) - [ ] DROP PACKAGE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-PACKAGE.html#GUID-FAE96214-2ED0-4130-8ACA-A077C7A90B23) - [ ] DROP PLUGGABLE DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-PLUGGABLE-DATABASE.html#GUID-4A663783-E184-417A-8BE1-703E1CDBA30B) - [ ] DROP PROCEDURE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-PROCEDURE.html#GUID-D7F2B5AD-DEEE-466B-B6D3-B765EB897DCB) - [ ] DROP PROFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-PROFILE.html#GUID-2892A481-F2C8-4B62-8960-E593D1150D83) - [ ] DROP RESTORE POINT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-RESTORE-POINT.html#GUID-5FC039A9-46C8-4604-8985-C29CB617798C) - [ ] DROP ROLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-ROLE.html#GUID-F5DEDFAF-EDE6-4733-8E17-C5B94E3168DB) - [ ] DROP ROLLBACK SEGMENT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-ROLLBACK-SEGMENT.html#GUID-26B4C9D6-EFB4-4523-B84D-FAD42060D3D4) - [ ] DROP SEQUENCE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-SEQUENCE.html#GUID-32B640EE-47C9-46A7-9746-6125BAF8FF8C) - [ ] DROP SYNONYM [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-SYNONYM.html#GUID-C7293D40-83B8-4E60-9E90-CB907F2CA6C7) - [x] DROP TABLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-TABLE.html#GUID-39D89EDC-155D-4A24-837E-D45DDA757B45) - [ ] DROP TABLESPACE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-TABLESPACE.html#GUID-C91F3E94-4503-48DE-9BCA-42E495E6BE11) - [ ] DROP TABLESPACE SET [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-TABLESPACE-SET.html#GUID-B14EC4C4-87C2-4E79-AB1A-044B620DF1FE) - [x] DROP TRIGGER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-TRIGGER.html#GUID-724AC8BC-0428-43D3-8F11-4D4AD8DC2984) - [ ] DROP TYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-TYPE.html#GUID-2CBA2EFD-1B01-46A8-A4CD-B2975D3A1D67) - [ ] DROP TYPE BODY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-TYPE-BODY.html#GUID-9D661F88-2174-4D21-87CA-CC6A36385C05) - [ ] DROP USER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-USER.html#GUID-F766E1A2-6686-4734-89BA-0C5B4120B90E) - [x] DROP VIEW [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-VIEW.html#GUID-1A1BD841-66B9-47E4-896F-D36E075AE296) #### DDL-OTHER - [x] ANALYZE [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ANALYZE.html#GUID-535CE98E-2359-4147-839F-DCB3772C1B0E) - [x] ASSOCIATE STATISTICS [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ASSOCIATE-STATISTICS.html#GUID-BD02BA6A-32A7-4093-A6B6-BAE860C0F834) - [x] AUDIT [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/AUDIT-Traditional-Auditing.html#GUID-ADF45B07-547A-4096-8144-50241FA2D8DD) - [x] COMMENT [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/COMMENT.html#GUID-65F447C4-6914-4823-9691-F15D52DB74D7) - [x] DISASSOCIATE STATISTICS [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DISASSOCIATE-STATISTICS.html#GUID-6E9A7D93-E28A-469D-97AB-2BECC2EF3C43) - [x] FLASHBACK DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK-DATABASE.html#GUID-BE0ACF9A-BC13-4810-B08B-33326440258B) - [x] FLASHBACK TABLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK-TABLE.html#GUID-FA9AF2FD-2DAD-4387-9E62-14AFC26EA85C) - [x] grant [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3) - [x] NOAUDIT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NOAUDIT-Traditional-Auditing.html#GUID-9D8EAF18-4AB3-4C04-8BF7-37BD0E15434D) - [x] PURGE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/PURGE.html#GUID-9257F773-E019-4464-80F4-F5AB61D7D9B6) - [x] RENAME [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/RENAME.html#GUID-573347CE-3EB8-42E5-B4D5-EF71CA06FAFC) - [x] revoke [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/REVOKE.html#GUID-BAAD2331-40A5-4366-86CA-BAA6B957E866) - [x] truncate table [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TRUNCATE-TABLE.html#GUID-B76E5846-75B5-4876-98EC-439E15E4D8A4) #### Transaction Control Statements - [x] commit [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/COMMIT.html#GUID-6CD5C9A7-54B9-4FA2-BA3C-D6B4492B9EE2) - [x] rollback [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ROLLBACK.html#GUID-94551F0C-A47F-43DE-BC68-9B1C1ED38C93) - [x] savepoint [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SAVEPOINT.html#GUID-78EEA746-0021-42E8-9971-3BA6DFFEE794) - [x] set transcation [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SET-TRANSACTION.html#GUID-F11E1E30-5871-48D1-8266-F80A1DF126A1) - [x] SET CONSTRAINT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SET-CONSTRAINTS.html#GUID-1EF5B212-17C5-4F7C-9412-D777DFDEDCE9) #### Session Control Statements - [x] ALTER SESSION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-SESSION.html#GUID-27186B28-7EFC-4998-B1ED-2B905CC0211B) - [x] SET ROLE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SET-ROLE.html#GUID-863F9B6F-82B4-4C49-8E3A-3BA33AE79CAB) #### System Control Statement - [x] ALTER SYSTEM [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-SYSTEM.html#GUID-2C638517-D73A-41CA-9D8E-A62D1A0B7ADB) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@shardingsphere.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
