Oracle Database 23c: New feature highlights
Based on this fascinating Twitter thread by Philipp Salvisberg covering the presentation by Gerald Venzl at DOAG 2022 I would like to…
medium.com
<< 요약 >>
1. Select without FROM
2. Use column alias in GROUP BY and HAVING
3. Test for object existence in DDL statements using IF EXISTS and IF NOT EXIST(S?)
: SQL SERVER 처럼 OBJECT 존재 유무로 로직 분기 가능
4. Table Value Constructor — allows to group multiple rows of data in a single DML or SELECT statement.
5. Returning Clause for MERGE statement and also returning OLD column value for UPDATE.
6. Better error messages to explain why a statement failed to execute.
: SQL 에러 메시지가 좀더 직관적이고 자세하게 표기됨, 에러가 모호해서 에러원인 파악이 힘들었는데, 대환영
7. Annotations — define meta data for database objects.
8. Developer Role — quickly provide a user with useful privileges for doing database development.
9. JavaScript Stored Procedures
10. SQL Domains
11. Update records based on a join condition
12. Schema Level Privileges
13. JSON Schema