Support New Features/Changes in PL/SQL Grammar 23c

[PhilippSalvisberg]

The currently supported PL/SQL grammar is 21c. See supported versions

We should add support for 23c.

Reference

See

• Oracle Database New Features 23c
• PL/SQL Language Reference

New Features in PL/SQL Language Reference

• [x] SQL BOOLEAN Data Type
• [x] IF [NOT] EXISTS Syntax Support
  • [x] CREATE FUNCTION
  • [x] CREATE LIBRARY
  • [x] CREATE PACKAGE
  • [x] CREATE PACKAGE BODY
  • [x] CREATE PROCEDURE
  • [x] CREATE TRIGGER
  • [x] CREATE TYPE
  • [x] CREATE TYPE BODY
  • [x] ALTER FUNCTION
  • [x] ALTER LIBRARY
  • [x] ALTER PACKAGE
  • [x] ALTER PROCEDURE
  • [x] ALTER TRIGGER
  • [x] ALTER TYPE
  • [x] DROP FUNCTION
  • [x] DROP LIBRARY
  • [x] DROP PACKAGE
  • [x] DROP PROCEDURE
  • [x] DROP TRIGGER
  • [x] DROP TYPE
  • [x] DROP TYPE BODY
• [x] Extended CASE Controls
  • [x] dangling_predicate
  • [x] comma separated list of (dangling_predicate|selector_value)
  • [x] Simple Case Statement
  • [x] Simple Case Expression
• [x] JSON Constructor and JSON_VALUE Support of PL/SQL Aggregate Types - probably no grammar change
• [x] Multilingual Engine Module Calls (call_spec, javascript_declaration)
  • [x] ALTER TYPE
  • [x] CREATE FUNCTION
  • [x] CREATE PROCEDURE
  • [x] CREATE TYPE
  • [x] CREATE TYPE BODY
  • [x] CREATE PACKAGE
  • [x] CREATE PACKAGE BODY

[PhilippSalvisberg]

closed with Azure DevOps commit 02d97182e801b9a4ffa8010f59043b3db18f75ca