There had been a SQL keyword enhancement recently, due to Issue 191.
These are more standard SQL keywords, that could be added to lang-sql.js (patch
attached)
- MATCHED (from the MERGE clause)
- NATURAL (for NATURAL JOIN)
- PARTITION (for PARTITION BY expressions)
Some Oracle-specific keywords:
- CONNECT (for the CONNECT BY clause)
- NOCYCLE (for the CONNECT BY NOCYCLE clause)
- PIVOT (for PIVOT tables, also available in SQL Server)
- START (for the CONNECT BY .. START WITH clause)
- UNPIVOT (for PIVOT tables, also available in SQL Server)
- WITHIN (for ordered aggregate functions: WITHIN GROUP ORDER BY)
- XML
Original issue reported on code.google.com by lukas.eder@gmail.com on 4 Aug 2012 at 9:36
Original issue reported on code.google.com by
lukas.eder@gmail.com
on 4 Aug 2012 at 9:36Attachments: