SQL Plus

SQLPlus is the first client of the Oracle Database.

SQL*Plus does not have a SQL or PL/SQL command parser. It scans the first few keywords of each new statement to determine the command type, SQL, PL/SQL or SQL*Plus.

• SQLPLUS - Variable
• SQLPlus - Environment Configuration
• Oracle Database - SQLPlus - Formatting SQL*Plus Reports
• SQLPlus - Useful Command
• SQLPlus - How to choose locally an instance with Environment Variables?

On windows, there is two versions of SQL*Plus :

• a GUI one (sqlplusw.exe) Officialy deprecated in the next release of Oracle.
• a DOS based character-mode one (sqlplus.exe)

To install the help on a instance :

@ORACLE_HOME\sqlplus\admin\help\hlpbld.sql helpus.sql;

To see the help :

• connect to an instance
• help index

• Documentation Reference
• Database Administration with SQL*Plus