Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Discover the latest enhancements in PL/SQL for Oracle Database 23c in this CloudWorld 2022 conference talk. Explore how to build efficient database APIs and manage data with improved features such as better loops, extended case expressions, and JavaScript Object Notation integration. Learn about currency conversion APIs, looping through arrays, using indices, qualified expressions, SQL macros, and textual find-replace functionalities. Gain insights from Chris Saxon, senior developer advocate at Oracle, on leveraging these new PL/SQL capabilities to simplify data processing and develop robust data-driven applications.
Syllabus
Introduction
Currency Conversion API
Looping through arrays
Using indices
Qualified Expressions
Loops
SQL Macros
Textual Find Replace
Review
Taught by
Oracle
Tags
Reviews
3.0 rating, based on 2 Class Central reviews
Showing Class Central Sort
-
PL/SQL is ideal for backend processing in Oracle-based websites, offering high performance, security, and efficient database handling. However, it's Oracle-specific, not for frontend use, and can be complex to debug. Best for data-heavy and secure web applications.
-
Overall, I highly recommend this SQL online class for anyone looking to improve their database skills. I came away with a solid foundation in SQL and feel well-prepared to tackle practical applications in the field.