Oracle Database application development: what's new, what's next?
summary
Oracle Database 23c is the next long‑term support release and only upgrades directly from 19c or 21c, ships “over 300 features,” and focuses on productivity and simplicity. New specifics: schema‑level privileges (grant ANY on a schema), annotations and reusable SQL domains (email example with display/order), JSON schema validation at storage or query time, Boolean type, JavaScript stored procedures via the MLE, extended limit to 4,096 columns, UPDATE via JOIN, IF EXISTS, enhanced RETURNING, a DBMS_DEVELOPER_ADMIN.GRANT_PRIVS helper, and clearer error messages.
AI-written summary · about
chapters (35)
- 0:00Introduction
- 0:21Oracle Database 23C
- 0:40Upgrade to 23C
- 1:18Why developers like Oracle Database
- 3:37Why operations like Oracle Database
- 4:10Two key goals for application development
- 6:50Schema level privileges
- 8:07Select on any table
- 9:15Annotations
- 10:02Keyvalue pairs
- 11:12Keyvalue pairs on columns
- 11:53SQL Domains
- 13:13Object Domains
- 14:41Reusing Domain
- 15:42Domain Display Domain Order
- 17:45Column Limits
- 18:43Json Schemers
- 20:22Schema Validation
- 21:46Boolean Data Type
- 22:35Update Base Tables
- 23:11JavaScript Store Procedure
- 24:26If Not Exist
- 25:47Group By
- 26:39Table Values
- 27:18Value Scan
- 27:46Enhanced Returning Clause
- 28:24Developer Role
- 28:49System Privileges
- 29:11Expression Helper
- 29:45Better Error Messages
- 30:18Invalid Number
- 30:45Select from table that does not exist
- 31:00Which table of view does not exist
- 31:13Database name that is not there
- 31:32Conclusion
related talks
20mImprove Your Data Strategy with Database 23ai
29mDatabase: What's new, what's next
24mRethinking Database Architecture to Embrace Modern App Dev
12mKey AI Innovations in Oracle Database 23ai
18mData Superpowers with Oracle Database 23ai
29mDatabase upgrade best practices: Upgrade now
14mUpgrade to Oracle Database 23ai
31mDatabase 21c for .NET and Visual Studio Code Developers