To Do List: Missing Oracle specific statements

[manticore-projects]

This is just a reminder for myself, so far I found the following Oracle specific statements missing:

• ~~ALTER SYSTEM~~ Fixed by PR #1288
• ~~RENAME table TO ...~~ Fixed by PR #1286
• ~~PURGE ...~~ Fixed by PR #1287
• ~~ALTER TABLE ... DROP for multiple columns~~ fixed by PR #1379
• ~~ALTER TABLE ... ADD for multiple columns~~ fixed, it is working in JSQLFormatter
• INSERT for multiple values
• ~~ALTER TABLE ... MOVE TABLESPACE ...~~ fixed by PR #1293

Please feel free to add to the list. I would want to implement these statements eventually.

[AnEmortalKid]

More oracle things missing as far as I remember: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm

[wumpz]

For sure. And from I think nearly 300 test sqls at the moment 172 are parsed successfully. Look into SelectOracleTest.

[manticore-projects]

More oracle things missing as far as I remember: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm

Greetings, please clarify because I think that Hierarchical Queries have been implemented yet and I also have added support for CONNECT_BY_ROOT via PR #1282. What is left open please?

[manticore-projects]

For sure. And from I think nearly 300 test sqls at the moment 172 are parsed successfully. Look into SelectOracleTest.

Good chunk from the failing tests is about Oracle's MultiInsert. How do you want me to approach this: a) refactor and amend the existing Insert or b) provide a new MultiInsert instead (including the standard compliant multiple VALUES syntax)

At the moment I tend to go route b) but am a kind of undecided. Please advise.