Oracle 23ai New Features Part 1 (June 2024)

OS Environment : Oracle Linux 8.4 (64bit)

 

DB Environment : Oracle Database 23.5.0.24.07 ai for Oracle Cloud and Engineered Systems

 

Title : Oracle 23ai New Features Part 1 (June 2024)

I'm sharing the presentation materials from the Oracle 23ai new features Part 1 seminar held in June 2024.

202406_Oracle_23ai_NF_Part1_eng.pdf

7.77MB

 

*This document has been translated from Korean to English, so the translation may not be perfectly smooth. 
I appreciate your understanding.

 

 

Index
1. Introduction to Oracle 23ai
2. Oracle 23ai Key New Features Part 1
Support for AI Vector Search
IF [NOT] EXISTS Clause
SELECT Statement without FROM Clause
Using GROUP BY Clause Alias ​​and Position
Wide Tables
DIRECT JOIN for UPDATE and DELETE Statements
UPDATE Syntax DEFAULT ON NULL
Table Value Constructor(TVC)
Setting PDB Startup Order
PDB Hybrid OPEN Mode
3. Oracle 23ai Free RPM Installation for Linux
4. Oracle ADB SELECT AI

 

 

Reference : 

Oracle 23ai New Features Summary ( https://positivemh.tistory.com/1103 )

Oracle 23ai New Features Part 2 (Oct 2024) ( https://positivemh.tistory.com/1185 )