You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:44:16 UTC

[GitHub] [shardingsphere] jingshanglu opened a new issue, #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

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)
   - [x] 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
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] ALTER CLUSTER [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-CLUSTER.html#GUID-A4E03C13-7690-4567-9B0A-DA6A21173B4D)
   - [x] ALTER DATABASE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DATABASE.html#GUID-8069872F-E680-4511-ADD8-A4E30AF67986)
   - [x] 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)
   - [x] 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)
   - [x] ALTER DISKGROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DISKGROUP.html#GUID-22D73AB6-7063-4627-A2ED-18D521ED2557)
   - [x] 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)
   - [x] ALTER FUNCTION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-FUNCTION.html#GUID-6FB32876-2DB3-41EB-B0CA-91B163826AB2)
   - [x] 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)
   - [x] ALTER INDEXTYPE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-INDEXTYPE.html#GUID-BFA7E29C-7905-4811-9119-B20FD8EA18F2)
   - [x] 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)
   - [x] ALTER JAVA [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-JAVA.html#GUID-6B211750-3247-4D71-9533-3DD8F66640CD)
   - [x] ALTER LIBRARY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-LIBRARY.html#GUID-BB90AF66-3B1F-46C4-9716-4578DE0AE1F3)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] ALTER OPERATOR [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-OPERATOR.html#GUID-F00A0AC8-36C8-4EAC-A9BB-B3D42C5EEEDE)
   - [x] ALTER OUTLINE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-OUTLINE.html#GUID-49F25C82-0783-4407-88BB-613F986C2FEC)
   - [x] ALTER PACKAGE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-PACKAGE.html#GUID-47471C4C-03AB-4D78-A295-3D58C91102E0)
   - [x] 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)
   - [x] 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)
   - [x] CREATE CONTEXT [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-CONTEXT.html#GUID-FDF62812-A884-479C-9C1B-5BD6DDEFE7FA)
   - [x] 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)
   - [x] CREATE DIRECTORY [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-DIRECTORY.html#GUID-8E9C569A-1B06-42C4-9586-0EF83437001A)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] CREATE SEQUENCE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SEQUENCE.html#GUID-E9C78A8C-615A-4757-B2A8-5E6EFB130571)
   - [x] CREATE SPFILE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SPFILE.html#GUID-D3E295B7-A3A4-43D3-8BBD-5CBE171A2E52)
   - [x] 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)
   - [x] DROP DISKGROUP [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DISKGROUP.html#GUID-6F77FABB-3365-448F-8E2B-9B776904182C)
   - [x] DROP EDITION [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-EDITION.html#GUID-726082F7-C931-4975-8F2B-5EA814A51AB0)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] DROP OPERATOR [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-OPERATOR.html#GUID-48E60BB4-9490-4B8B-B08E-D17EAEBDDD7E)
   - [x] DROP OUTLINE [doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-OUTLINE.html#GUID-776F36E0-1905-48DC-9062-FBFAD5E1C36F)
   - [x] 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)
   - [x] 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)
   - [x] 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)
   - [x] 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-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-2028457540

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] Jacob953 commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
Jacob953 commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1103989421

   Hi, @strongduanmu, I'd like to try the following DDL-ALTER first.
   
   - [ ] ALTER TABLE
   - [ ] ALTER TYPE


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1104580681

   > * ALTER
   
   @Jacob953 Welcome, I will assign this issue to you.


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1131787217

   > I'd like to try the following DDL-CREATE first.
   
   @csonezp Welcome.


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] everly-gif commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
everly-gif commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1093583952

   Thanks @Liangda-w , I will be claiming some soon :)


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] csonezp commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1131519060

   Hi @strongduanmu , I want to work on this first:
   - [ ] CREATE SPFILE
   


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1120209652

   > Hi @strongduanmu, I want to work on this first:
   > 
   > * [ ]  `DROP EDITION`
   
   @chakkk309 Great.


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] strongduanmu closed issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions
URL: https://github.com/apache/shardingsphere/issues/6480


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] csonezp commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1131517926

   - [ ] CREATE SPFILE


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] csonezp commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1131782060

   > I'd like to try the following DDL-CREATE first.
   > 
   > * [ ]  CREATE SPFILE
   
   Hi @strongduanmu ,
   
   When I am writing code for X, I have a problem. 
   SPFILE means "server parameter file".
   
   what name should i define it in DDLStatement.g4? createSPFile?  


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] csonezp commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1131526587

   I'd like to try the following DDL-CREATE first.


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] github-actions[bot] commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1272351048

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] csonezp commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1132636313

   I'd like to try the following DDL-CREATE :
   - CREATE PFILE
   - CREATE OUTLINE


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] Liangda-w commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
Liangda-w commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1093351175

   Hey @everly-gif, just in case you're interested in some more Oracle SQL tasks, feel free to claim subtasks in the list that are not finished yet:)


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] github-actions[bot] closed issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions
URL: https://github.com/apache/shardingsphere/issues/6480


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] chakkk309 commented on issue #6480: [SQL Definition Collation][Oracle]Collate the g4 files of SQL definitions

Posted by GitBox <gi...@apache.org>.
chakkk309 commented on issue #6480:
URL: https://github.com/apache/shardingsphere/issues/6480#issuecomment-1120126386

   Hi @strongduanmu, I want to work on this first: 
   - [ ] `DROP EDITION` 


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org