Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Chapter 12. SQL*Plus

SQL*Plus is the command-line interface to the Oracle database and is probably the most frequently used Oracle utility. This utility allows you to enter SQL statements and PL/SQL code and execute script files. Although some of its functionality is also offered by other products, such as Recovery Manager, Enterprise Manager, and the various Oracle reporting tools, the longevity and wide-ranging capabilities of SQL*Plus keep it in most Oracle practitioners’ toolkits.

SQL*Plus is also one of the oldest of the Oracle utilities. It actually started life as the User Friendly Interface (UFI), the command-line interface for IBM’s System R, one of the first relational database systems. In the 1980s, Oracle started adding features to UFI and soon renamed it AUFI (for Advanced User Friendly Interface). When Oracle 5.0 was released in 1985, the name of the product was changed to SQL*Plus. With each new release of Oracle, new commands and options have been added to this venerable product, but the core of SQL*Plus is still fundamentally the same.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page