The SQL*Plus (pronounced "sequel plus") User's Guide and Reference introduces SQL*Plus and its uses, and describes each SQL*Plus command.

This preface contains these topics:


The SQL*Plus User's Guide and Reference is intended for business and technical users and system administrators who perform the following tasks:

  • Develop and run batch scripts

  • Format, calculate on, store, print and create web output from query results

  • Examine table and object definitions

  • Perform database administration

This document assumes a basic understanding of the SQL language. If you do not have familiarity with SQL, see the Oracle Database SQL Language Reference. If you plan to use PL/SQL with SQL*Plus, see the Oracle Database PL/SQL Language Reference.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Related Documents

For more information, see these Oracle resources:

Many of the examples in this book use the sample schemas, which you need to download from the GitHub repository. See Oracle Database Sample Schemas for information on how these schemas were created and how you can use them yourself.

SQL*Plus error message documentation is available in SQL*Plus Error Messages. Oracle Database error message documentation is only available in HTML. If you only have access to the Oracle Database Documentation media, you can browse the Oracle Database error messages by range. Once you find the specific range, use your browser's "find in page" feature to locate the specific message. When connected to the Internet, you can search for a specific error message using the error message search feature of the Oracle Database online documentation.


The following text conventions are used in this document:

Convention Meaning


Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.


Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.


Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.