This course covers the new functionalities of Oracle Database for developing faster, simpler, and more modern cloud-native applications. Students will learn about advances in SQL and PL/SQL, integration into cloud-native environments, and continuous integration and delivery. The course aims to simplify developers' lives and increase productivity by providing insights into upcoming changes in Oracle Database application development. The course teaches schema level privileges, key-value pairs, SQL and object domains, JSON schemas, JavaScript stored procedures, and error handling techniques. The intended audience for this course includes developers and individuals interested in Oracle Database application development.
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
