SQLPLUS Survival Tips
Editing commands in SQLPLUS
The SQLPLUS interface is not very user-friendly. The best method of
using it may be to open a Notepad file in a second window. Edit
commands in the notepad file. Then copy and paste them into SQLPLUS.
Note that the slash "/" may not work if copied and pasted.
If you want to invoke an editor from within SQLPLUS, here is how:
In the SQLPLUS Window menu, click on Options-Environment-editfile.
Select "Custom". Insert "H:\" before "afiedt.buf". Once you have done
this, you can invoke the editor by typing
edit (or ed) in SQLPLUS.
Don't include a semicolon at the end of the command if using the editor.
Type r to run a command after editing.
Other useful SQLPLUS commands
to look at the system catalog of your tables:
select * from cat
look at table details:
to stop information from scrolling off the screen:
set pause on
(but then you need to press enter twice after issuing an SQL command)
if backspace does not work: use Ctrl h
to re-execute the previous command type /
for help type help index
(but the on-line documentation is better! See below)
to exit type exit
Oracle On-line Documentation
To use some of this documentation you need to sign up
for a free Oracle OTN user account. You will be prompted for your
email address once you click on any of the links below.
SQLPlus Quick Reference
Oracle9i Application Developer's Guide -
Oracle 9i Release 2.
Oracle 9.0.1 Documentation