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, ...

Get Oracle SQL Developer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.