Oracle Database Application Development - What's New, What's Next
Offered By: Oracle via YouTube
Course Description
Overview
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.
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
Tags
Related Courses
Take Recruiting to the Next Level with Innovations for Oracle RecruitingOracle via YouTube Oracle at Oracle - Future-Ready Supply Chain
Oracle via YouTube Adding Resilience and Redundancy from On-Premises to Oracle Cloud Infrastructure
Oracle via YouTube Get Dashboards to the Next Level with Oracle Analytics Best Practices and Tips
Oracle via YouTube Oracle Cloud VMware Solution - Sizing and Scaling
Oracle via YouTube