CRITICAL SKILL 6.4

Write PL/SQL Programs in SQL*Plus

When we write PL/SQL programs, we have a couple of options on how to run a program. A program may be run directly in SQL*Plus (or some other SQL environment), or it can be stored in the database and then run from a SQL environment or a program. When you store a program in the database, we call this a stored program or stored object. We’ll cover this later in the chapter. For now let’s discuss how to write a program using SQL*Plus.

Progress Check Answers

1. Any four from among the following would be acceptable answers: Oracle Forms, Reports, Warehouse Builder, Oracle Applications, Oracle Portal, SQL*Plus, Oracle Grid Control, Oracle Pre-compilers, and Oracle Application Server.

2. The three ...

Get Oracle Database 10g: A Beginner's Guide 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.