Oracle Database 23c: What's New in SQL

In the world of database, Oracle has long been recognized as a powerhouse. It offers a wide range of features and capabilities that make it a preferred choice for many organizations. One aspect that has often set Oracle apart from other databases are SQL features. In a recent update, Oracle Database 23c has introduced a new set of SQL enhancements making commands more intuitive and easier to use for developers.  In this session, we will cover the Oracle Database 23c SQL enhancements including the following:Boolean Data TypeThe Boolean data type in Oracle Database 23c offers a more intuitive and expressive way storing and manipulating logical values.Select without From DualIn Oracle, the “FROM DUAL” clause is typically used in queries when a table reference is required but no actual table is needed. To align with industry standards and enhance the user experience, Oracle has introduced a feature that removes the need for the “FROM DUAL” clause in certain scenarios. Schema-level PrivilegesWith Schema-level Privileges you now have the ability to grant access to an object type for a schema.  Prior to 23c, you had to grant access to every object of the entire schema.4096 ColumnsTables in 23c can have even more columns with a maximum of 4096 columns.Table Value ConstructorGroup By Column AliasIf [NOT] ExistsEnhanced RETURNING ClauseUpdate via JoinDelete via JoinWith Oracle Database 23c SQL Enhancements you benefit from<ol><li>Improved Readability: leads to cleaner and more conciseness</li><li>Easier Migration: As organizations adopt multi-database strategies or migrate from one database to another, developers and database administrators will find it easier to transition from other database platforms to Oracle. </li><li>Consistency across Platforms: The enhanced approach promotes consistency.</li><li>Enhanced Developer Productivity: The streamlined syntax saves developers time and effort, allowing them to focus on more critical aspects of their work. </li></ol>Oracle has taken a significant step towards making its SQL more intuitive and user-friendly. The streamlined approach not only simplifies construction but also facilitates easier migration and fosters consistency across database platforms. As a result, Oracle users can now enjoy a more seamless experience, enhancing their productivity and overall satisfaction with the database system.

Outline

Oracle Database 23c Overview

New SQL Enhancements

Joins in UPDATE/DELETE
GROUP BY Aliases or Positions
UPDATE RETURN clause
SELECT Without FROM
Table Value Constructor
IF [NOT] EXISTS
Wider Tables (aka 4096 Columns Per Table)
Boolean Data Type

Prerequisites

Oracle Database proficiency

SQL proficiency

Objectives

Oracle Database 23c has introduced a new set of SQL enhancements. In this workshop, we will cover the Oracle Database 23c SQL enhancements making commands more intuitive and easier to use for developers.

#SELECTION#

#ICON_HTML#

Oracle Database 23c web page (Website)

#MISC#

#ACTIONS#

Featured Speakers

Session Has Completed - 11 April 2024

Duration

1 Hour

Series Name

Location:

English

Audience

Analyst, Architect, Database Administrator, Developer

Products

SQL

Featured Speaker Translation

Featured Speakers

Featured Speaker Translation

Join

Featured Speaker Translation

English

Featured Speaker Translation

Unregister

Featured Speaker Translation

Outline

Featured Speaker Translation

Objectives

Featured Speaker Translation

Resources

Featured Speaker Translation

11 April 2024

Featured Speaker Translation

Session Has Completed - 11 April 2024

Featured Speaker Translation

You Are A Speaker/Panelist

Featured Speaker Translation

1 Hour

Featured Speaker Translation

Pending

Featured Speaker Translation

Prerequisites

Featured Speaker Translation

Waitlisted

Featured Speaker Translation

Rejected

Featured Speaker Translation

Question And Answer

Featured Speaker Translation

Analyst, Architect, Database Administrator, Developer

Featured Speaker Translation

Add To Calendar

Featured Speaker Translation

Registration Status

Featured Speaker Translation

Series Name

Featured Speaker Translation

Session Time

Featured Speaker Translation

You Are Registered. You Will Be Able To Join The Session 15 Minutes Before It Starts.

Oracle Database 23c: What's New in SQL

Resources

Oracle Database 23c web page (Website)

Featured Speakers

Workshop Info

Hidden Translations