 |
|
Oracle Concepts by Burleson
Consulting |
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
menus
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
DOS.
To enter SQL*Plus, you simply type “sqlplus” at
the command prompt, including the user name, password and Oracle
database name. For example:
sqlplus
pubs/pubs@mydb
cd c:\oracle\sql
sqlplus
system/manager@mydb
select * from
v$database;
host notepad
query1.sql
@query1
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:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
