Entering and Executing Commands

Use the following commands to execute and collect timing statistics on SQL commands and PL/SQL blocks.

/ (slash)

Executes the SQL command or PL/SQL block currently stored in the SQL buffer. Does not list the command.

EXEC[UTE] statement

Executes a single PL/SQL statement.

R[UN]

Lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer.

TIMI[NG] [START text|SHOW|STOP]

Records timing data for an elapsed period of time, lists the current timer's name and timing data, or lists the number of active timers.

Use the following command to access the help system.

HELP [topic]

Accesses help on SQL*Plus commands.

Use the following command to execute host operating system commands.

HO[ST] [command]

Executes a host operating system command without leaving SQL*Plus.