O'Reilly logo

Oracle SQL Developer by Ajith Narayanan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Working with PL/SQL

Unique to the Oracle database, PL/SQL code forms the core of many Oracle database applications. Whether a database-centric application or one using open source technologies, if the Oracle database underpins the application, PL/SQL code is almost certainly present and is stored in the database or sent in blocks of code to the database for execution. PL/SQL is a language extension to SQL, offering a procedural language structure in the Oracle Database, which is required for more complex application development. SQL Developer supports PL/SQL development by allowing you to work with text files or develop and test code directly against the database.

In this section, we will review this support and show you how to create, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required