O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

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

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

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