SQLPLUS Login

To get started: On the XP Menu, go to Programs - Core - Oracle 9i.

You will get an Oracle user name and password assigned by Gordon or Uta.

User Name: your_oracle_username
Password: your_oracle_password
Host String: SOC3.UK.DCS.NAPIER.AC
You should change your password when you first login. Type "password" to do this.

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: describe tablename
  • 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.

  • SQL Reference
  • SQLPlus Quick Reference
  • Oracle9i Application Developer's Guide - Object-Relational Features
  • Oracle 9i Release 2.
  • Oracle 9.0.1 Documentation