From the course: Oracle Database 12c: Advanced SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Introduction to PL/SQL procedures

Introduction to PL/SQL procedures - Oracle Database Tutorial

From the course: Oracle Database 12c: Advanced SQL

Start my 1-month free trial

Introduction to PL/SQL procedures

“

- If you are taking this course after you have completed the Oracle basic SQL course that is also available in the content library, you should already know how to interact with the database using SQL commands. However, as you probably already know, SQL commands and SQL queries are also somewhat limited in terms of their capabilities. SQL is easy to use, but lacks certain functionality which is required to enable full database programming. Functionality such as created stored complex programs. Or using conditional logic, or even using advanced types and defining variables. For that reason the Oracle database also extends the capabilities of the standard SQL language with a unique programming language known as PL/SQL. Which stands for ProceduraL SQL. PL/SQL is a third generation procedural language that has tight integration with SQL making it possible to build complex and powerful application logic and store it inside the Oracle database itself. Because PL/SQL is executed from within…

Contents