From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

PL/SQL

PL/SQL - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

PL/SQL

“

- [Instructor] PL/SQL was introduced with Oracle 6 Forms, then integrated into Oracle 7 soon afterwards. This incredibly robust and versatile SQL programming language is now one of the top in the world. PL/SQL is a block-structured language, and having previous coding experience can be very beneficial in understanding recommended coding practices, which should be followed with PL/SQL. PL/SQL can be used to build out procedures, triggers, and packages. With conditional branching and iterative processing, all logic can be built into the database layer for ease of management and added performance. Full error handling and robust functions provide enhanced development features for any enterprise application's needs. PL/SQL has advanced formatting and translations of data types, including dates, numbers, strings, and the ability to process data via rays, driving faster performance. PL/SQL cursors can take this one step further, working with more data in memory. PL/SQL also has advanced…

Contents