||Oracle Concepts by Burleson
Getting Started with SQL*Plus
The following exercise will show you how to
develop SQL queries using Oracle’s SQL*Plus.
The SQL*Plus utility is a simple online command
editor that allows you to enter SQL commands directly into Oracle.
There are two ways to get into SQL*Plus:
1 – Using the GUI tool from the pull-down
2 – Opening a DOS window
We highly recommend that you enter SQL*Plus from
the DOS window because it is far easier to edit and execute file from
To enter SQL*Plus, you simply type “sqlplus” at
the command prompt, including the user name, password and Oracle
database name. For example:
select * from
At any time, you can use the “host” command to
shell-out to DOS and execute any DOS commands that you desire:
SQL> host dir
SQL> host copy c:\oracle\query5.sql c:\docs
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA