Chapter 2Using SQL*Plus and JDeveloper

Knowing how to develop and run PL/SQL doesn't do much good unless you have a place to run it. Oracle provides GUI and command-line utilities to create and debug PL/SQL code, and then run and maintain it.

In this chapter we discuss PL/SQL execution and development using SQL*Plus and JDeveloper. SQL*Plus, the most widely used utility shipped with the data server, provides an interface to the database that is flexible and always available. JDeveloper, once strictly a Java development tool, now includes features for managing database objects and developing PL/SQL.

The section on SQL*Plus covers

Image Connecting to ...

Get Oracle Database 10g PL/SQL Programming 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.