SQL 23c

Oracle database 23c SQL New Features

Oracle 23c - SQL

Introducing Annotations: A New Frontier for Metadata

Oracle Database 23c introduces significant enhancements to the simple CASE statement and expression, offering increased flexibility and alignment with the SQL:2003 standard. These enhancements include: Dangling Predicates and Multiple Choices or Conditions in a Single WHEN Clause. We will demonstrate those enhancements in this article.

Introducing Annotations: A New Frontier for Metadata Read More »

Oracle 23c - SQL

Enhanced Control Flow with CASE in Oracle Database 23c

Oracle Database 23c introduces significant enhancements to the simple CASE statement and expression, offering increased flexibility and alignment with the SQL:2003 standard. These enhancements include: Dangling Predicates and Multiple Choices or Conditions in a Single WHEN Clause. We will demonstrate those enhancements in this article.

Enhanced Control Flow with CASE in Oracle Database 23c Read More »

Oracle 23c - SQL

BOOLEAN Data Type is Finally Supported in Oracle SQL 23c

Prior to Oracle Database 23c, representing logical values like TRUE and FALSE in tables was, well, less than straightforward. We resorted to creative juggling acts, employing numbers, characters, or even entire table structures to mimic binary states. The result? Code shrouded in cryptic workarounds, data prone to misinterpretations, and performance begging for optimization. With 23c, Oracle finally embraces

BOOLEAN Data Type is Finally Supported in Oracle SQL 23c Read More »

Oracle 23c - SQL

GROUP BY and HAVING Clauses with Column Aliases and Positions (23c)

Oracle Database 23c introduces enhancements to GROUP BY and HAVING clauses, empowering developers to write more concise, readable, and maintainable SQL queries. These improvements include: Pre-23c Restrictions: Oracle 23c Empowers Simplicity: Column Aliases in Action: Column Positions in GROUP BY: HAVING with Aliases: Conclusion The advancements in GROUP BY and HAVING clauses within Oracle 23c offer benefits for

GROUP BY and HAVING Clauses with Column Aliases and Positions (23c) Read More »

Oracle 23c - SQL

Enforcing Default Values when Updating Columns to NULL (23c)

Oracle Database 23c introduces a powerful new feature that empowers developers and DBAs to maintain data integrity and simplify application logic: the ability to define columns as DEFAULT ON NULL for update operations. This enhancement builds upon the existing DEFAULT ON NULL functionality for insert operations, extending its benefits to update scenarios as well.

Enforcing Default Values when Updating Columns to NULL (23c) Read More »

Oracle 23c - SQL

Aggregation over INTERVAL Data Types in Oracle 23c

In Oracle database 23c, you can pass INTERVAL data types to the SUM and AVG aggregate and analytic functions. This feature streamlines operations involving time intervals, making it more convenient for developers and data analysts. In addition to that, this feature avoids potentially performance-intensive conversions, leading to faster query execution. In Oracle Database, INTERVAL data types represent a

Aggregation over INTERVAL Data Types in Oracle 23c Read More »

Scroll to Top