tuichenchuxin edited a comment on issue #6480: URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-986512763
I clone the oracle grammer list from [offical doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/index.html), and add this sub task for community to have a guide book to add .g4 file. #### 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) - [ ] 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) - [ ] 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) - [ ] 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) - [ ] 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) - [ ] 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) - [ ] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
