Useful SQLPlus Commands

The SQLPLUS utility is the Oracle equivalent of iSQL.

It includes a few shortcuts to make life easier:


This will excecute FILENAME (or FILENAME.SQL)


This will show the detailed errors for the last command.


This lists the last command entered.

Beware that stored procedures or functions cannot include blank lines (as far as i can tell – I got so many errors that I removed them).

Without some of these commands it is as user-friendly as a cornered rat.

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s