Commong SQL PLUS Commands


ACCEPT – Get input from the user

DEFINE – Declare a variable (short: DEF)

DESCRIBE – Lists the attributes of tables and other objects (short: DESC)

EDIT – Places you in an editor so you can edit a SQL command (short: ED)

EXIT or QUIT – Disconnect from the database and terminate SQL*Plus

GET – Retrieves a SQL file and places it into the SQL buffer

HOST – Issue an operating system command (short: !)

LIST – Displays the last command executed/ command in the SQL buffer (short: L)

PROMPT – Display a text string on the screen. Eg prompt Hello World!!!

RUN – List and Run the command stored in the SQL buffer (short: /)

SAVE – Saves command in the SQL buffer to a file. Eg “save x” will create a script file called x.sql

SET – Modify the SQL*Plus environment eg. SET PAGESIZE 23

SHOW – Show environment settings (short: SHO). Eg SHOW ALL, SHO PAGESIZE etc.

SPOOL – Send output to a file. Eg “spool x” will save STDOUT to a file called x.lst

START – Run a SQL script file (short: @)

One thought on “Commong SQL PLUS Commands

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s