filmov
tv
Build Database APIs with PL/SQL in Oracle Database 23ai

Показать описание
With tight SQL integration, PL/SQL has long been the perfect language for building database APIs to manage your data.
Oracle Database 23ai continues to enhance PL/SQL with better loops, extended case expressions, and better JSON integration. And best of all: the automatic SQL transpiler, which removes the context switch between the SQL and PL/SQL languages! This gives you the code reuse benefits of PL/SQL with the performance of pure SQL.
These changes simplify your PL/SQL code, making it easier to read, write, and test. Watch this session to learn what’s new in PL/SQL to help you build data-driven applications.
Highlights of the session include:
02:40 - Exrate conversion function
03:10 - Pre-23ai API implementation
07:15 - PL/SQL loop enhancements in 21c demo
17:40 - Looping through arrays
22:40 - Qualified expressions/type constructors
28:15 - Scalar SQL macros
34:25 - Automatic SQL transpiler
37:30 - Demo of macros and transpiler
47:10 - Extended CASE controls
49:40 - JSON PL/SQL conversions
54:15 - Demo of updated API using 23ai functionality
56:50 - Recap
Oracle Database 23ai continues to enhance PL/SQL with better loops, extended case expressions, and better JSON integration. And best of all: the automatic SQL transpiler, which removes the context switch between the SQL and PL/SQL languages! This gives you the code reuse benefits of PL/SQL with the performance of pure SQL.
These changes simplify your PL/SQL code, making it easier to read, write, and test. Watch this session to learn what’s new in PL/SQL to help you build data-driven applications.
Highlights of the session include:
02:40 - Exrate conversion function
03:10 - Pre-23ai API implementation
07:15 - PL/SQL loop enhancements in 21c demo
17:40 - Looping through arrays
22:40 - Qualified expressions/type constructors
28:15 - Scalar SQL macros
34:25 - Automatic SQL transpiler
37:30 - Demo of macros and transpiler
47:10 - Extended CASE controls
49:40 - JSON PL/SQL conversions
54:15 - Demo of updated API using 23ai functionality
56:50 - Recap
Build Database APIs with PL/SQL in Oracle Database 23ai
PL/SQL My APIs!
Quick PL/SQL Code Generator - Generate CRUD APIs
Building REST APIs using SQL Developer & ORDS
SQLDeveloper Series - Building a Table API
Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL
PL/SQL and the Art of OCI Management
Oracle Restful API Create
Build Powerful and Secure REST APIs for Your Oracle Autonomous Database
How to Create REST API for database table using ORDS Oracle REST Data Services, What is ORDS? demo
Oracle E Business Suite Integrated SOA Gateway PL SQL API as REST Service
Using a Pl/SQL Table API to Implement Thick Database Principles by Peter Koletzke
Why PL/SQL is still the best data access language by Connor McDonald
Must Have DATA ENGINEERING PROJECTS for Your RESUME | #sql #coding
PostgreSQL in 100 Seconds
How to Creating, Modifying and Removing the Packages in pl/sql oracle database.
API concept in Oracle | Oracle Shooter
Calling Web Services from Oracle PLSQL
Calling Send Grid API using UTL_HTTP (SSL) for mails | PLSQL | SQL | Oracle Wallet | Oracle ACL
Rest API on Apex environment using SQL and PL/SQL
How to create REST API in oracle apex using GET method.
Calling a Web Service from Oracle Database Without Using Oracle Wallet
Java Database Connectivity | JDBC
Database Setup and Teardown for Automated Testing of PL/SQL Code
Комментарии