Oracle SQL Features
Project
Repository

Oracle SQL Features

    • Categories
      • JavaScript
        • All
          • Inline JavaScript Procedures
          • JavaScript Call Specifications
          • JavaScript Environments
          • JavaScript Modules
        • 23.2
          • Inline JavaScript Procedures
          • JavaScript Call Specifications
          • JavaScript Environments
          • JavaScript Modules
      • PL/SQL
        • All
          • Extended CASE Controls
          • PL/SQL Function in SQL
          • PL/SQL and JSON type conversions
          • SQL Transpiler
        • 12.1.0.1
          • PL/SQL Function in SQL
        • 23.2
          • Extended CASE Controls
          • PL/SQL and JSON type conversions
          • SQL Transpiler
      • SQL
        • All
          • 4096 table columns
          • Annotations
          • Boolean data type
          • CEIL, FLOOR, and ROUND for datetime data types
          • Default ON NULL for UPDATE statements
          • Enhanced Returning-Into Clause
          • FUZZY_MATCH operator
          • GROUP BY column alias or position
          • IF [NOT] EXISTS
          • Identity Columns
          • JSON Schema: check constraint
          • JSON Schema: validate rows in a table
          • Native SQL Support for Query Row Limits and Row Offsets
          • PHONIC_ENCODE operator
          • PL/SQL Function in SQL
          • SELECT without FROM clause
          • SQL Transpiler
          • SUM and AVG over INTERVAL data types
          • Schema Level Privileges
          • Seamless concatenation via Varargs
          • Table Value Constructor
          • UPDATE/DELETE via JOIN
          • WINDOW clause
          • Window functions GROUPS frame
          • Window functions frame exclusion
        • 12.1.0.1
          • Identity Columns
          • Native SQL Support for Query Row Limits and Row Offsets
          • PL/SQL Function in SQL
        • 23.2
          • 4096 table columns
          • Annotations
          • Boolean data type
          • CEIL, FLOOR, and ROUND for datetime data types
          • Default ON NULL for UPDATE statements
          • Enhanced Returning-Into Clause
          • FUZZY_MATCH operator
          • GROUP BY column alias or position
          • IF [NOT] EXISTS
          • JSON Schema: check constraint
          • JSON Schema: validate rows in a table
          • PHONIC_ENCODE operator
          • SELECT without FROM clause
          • SQL Transpiler
          • SUM and AVG over INTERVAL data types
          • Schema Level Privileges
          • Seamless concatenation via Varargs
          • Table Value Constructor
          • UPDATE/DELETE via JOIN
        • 21.3
          • WINDOW clause
          • Window functions GROUPS frame
          • Window functions frame exclusion
    • Versions
      • 12.1.0.1
        • All
          • Identity Columns
          • Native SQL Support for Query Row Limits and Row Offsets
          • PL/SQL Function in SQL
        • PL/SQL
          • PL/SQL Function in SQL
        • SQL
          • Identity Columns
          • Native SQL Support for Query Row Limits and Row Offsets
          • PL/SQL Function in SQL
      • 21.3
        • All
          • WINDOW clause
          • Window functions GROUPS frame
          • Window functions frame exclusion
        • SQL
          • WINDOW clause
          • Window functions GROUPS frame
          • Window functions frame exclusion
      • 23.2
        • All
          • 4096 table columns
          • Annotations
          • Boolean data type
          • CEIL, FLOOR, and ROUND for datetime data types
          • Default ON NULL for UPDATE statements
          • Enhanced Returning-Into Clause
          • Extended CASE Controls
          • FUZZY_MATCH operator
          • GROUP BY column alias or position
          • IF [NOT] EXISTS
          • Inline JavaScript Procedures
          • JSON Schema: check constraint
          • JSON Schema: validate rows in a table
          • JavaScript Call Specifications
          • JavaScript Environments
          • JavaScript Modules
          • PHONIC_ENCODE operator
          • PL/SQL and JSON type conversions
          • SELECT without FROM clause
          • SQL Transpiler
          • SUM and AVG over INTERVAL data types
          • Schema Level Privileges
          • Seamless concatenation via Varargs
          • Table Value Constructor
          • UPDATE/DELETE via JOIN
        • JavaScript
          • Inline JavaScript Procedures
          • JavaScript Call Specifications
          • JavaScript Environments
          • JavaScript Modules
        • PL/SQL
          • Extended CASE Controls
          • PL/SQL and JSON type conversions
          • SQL Transpiler
        • SQL
          • 4096 table columns
          • Annotations
          • Boolean data type
          • CEIL, FLOOR, and ROUND for datetime data types
          • Default ON NULL for UPDATE statements
          • Enhanced Returning-Into Clause
          • FUZZY_MATCH operator
          • GROUP BY column alias or position
          • IF [NOT] EXISTS
          • JSON Schema: check constraint
          • JSON Schema: validate rows in a table
          • PHONIC_ENCODE operator
          • SELECT without FROM clause
          • SQL Transpiler
          • SUM and AVG over INTERVAL data types
          • Schema Level Privileges
          • Seamless concatenation via Varargs
          • Table Value Constructor
          • UPDATE/DELETE via JOIN
Oracle SQL Features latest
  • Oracle SQL Features
    • latest
  • Oracle SQL Features
  • Versions
Edit this Page

Versions

  • 12.1.0.1

  • 12.1.0.2

  • 21.3

  • 23.2

This page was built using the Antora default UI.

The source code for this UI is licensed under the terms of the MPL-2.0 license.