Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5655

Support Oracle 23c

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Unresolved
    • Icon: Major Major
    • 2.5-backlog
    • None
    • oracle-connector
    • None
    • False
    • None
    • False

      Oracle 23c is planned to end beta and go into GA sometime around February 2023, so it would be a cool new feature to add to Debezium 2.2 in Q1 2023.

      Some highlights for Oracle 23c include:

      1. SELECT without FROM, i.e. SELECT 2*3; (DBZ-7505)
      2. Using column aliases in GROUP BY and HAVING clauses (checked against current grammar and aliases get treated as expressions, which is sufficient for our purposes).
      3. Existence testing in DDL, i.e. CREATE TABLE tab IF NOT EXIST ... (DBZ-7498)
      4. Table Value Constructors
      5. New RETURNING keyword to get old/new values
      6. New error messages to explain SQL failures better
      7. Database object annotations - CREATE/ALTER TABLE (DBZ-7506)
      8. New developer role
      9. Javascript-based store procedure support
      10. New SQL domain types support
      11. Ability to issue updates against a table with a join condition
      12. Schema-level permissions
      13. JSON schema validation support
      14. Define 4096 columns per table, like woah???
      15. New BOOLEAN data type
      16. Oracle RAC support on K8s

      https://www.oracle.com/database/23c/#interval-data-type-aggregations

            ccranfor@redhat.com Chris Cranford
            ccranfor@redhat.com Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: