Using SQL Command Line

This section describes SQL Command Line (SQL*Plus), a command-line utility to run SQL and PL/SQL.

This contains the following topics:

Starting and Exiting SQL Command Line
Displaying Help With SQL Command Line
Entering and Executing SQL Statements and Commands
SQL Command Line DESCRIBE Command
SQL Command Line SET Commands
Running Scripts From SQL Command Line
Spooling From SQL Command Line
Using Variables With SQL Command Line

Note:

Before starting SQL Command Line, make sure that the necessary environmental variables have been set up properly. See Oracle Database Express Edition 2 Day DBA Guide for information about setting environmental variables for SQL Command Line.