Discover the latest advancements in Oracle Database application development in this informative CloudWorld 2022 conference talk. Explore new features and functionalities designed to simplify and accelerate modern, cloud-native application development. Learn about improvements in SQL and PL/SQL, integration with cloud-native and CI/CD environments, and productivity-enhancing tools. Gain insights into Oracle Database 23C upgrades, schema-level privileges, annotations, key-value pairs, SQL and Object Domains, JSON Schema validation, JavaScript stored procedures, and enhanced error messages. Understand how these innovations can streamline your development process and boost productivity. Delve into the reasons why both developers and operations teams prefer Oracle Database, and get a glimpse of future developments in database technology.
Oracle Database Application Development - What's New, What's Next
Overview
Syllabus
Introduction
Oracle Database 23C
Upgrade to 23C
Why developers like Oracle Database
Why operations like Oracle Database
Two key goals for application development
Schema level privileges
Select on any table
Annotations
Keyvalue pairs
Keyvalue pairs on columns
SQL Domains
Object Domains
Reusing Domain
Domain Display Domain Order
Column Limits
Json Schemers
Schema Validation
Boolean Data Type
Update Base Tables
JavaScript Store Procedure
If Not Exist
Group By
Table Values
Value Scan
Enhanced Returning Clause
Developer Role
System Privileges
Expression Helper
Better Error Messages
Invalid Number
Conversion failed
Select from table that does not exist
Which table of view does not exist
Database name that is not there
Conclusion
Taught by
Oracle
