Oracle:SQLPlus

From mi-linux
Revision as of 13:38, 13 January 2016 by Cm1958 (talk | contribs)
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Getting Started >> SQL*Plus

SQL*Plus Client

First of all start SQL*Plus - see this page for details: Starting SQL*Plus

It will then present you with a log on screen as shown on the following figure:

http://mi-linux.wlv.ac.uk/~oracle/wiki/SQLPlus_Client.png

Fill in the following, note the format of the username carefully:

User-name:This is your student number, preceded by OPS$ and followed by @ora12c
  E.g., if your username is 0912345, then type in: OPS$0912345@ora12c
Password:When you registered for Oracle, you will have been given a password. Type this in when prompted.
  Note, the password will not be echoed on the screen, nor any asterisks shown.

Do note that the password is case sensitive, but the user-name is not. Generally the password automatically generated starts with a capital letter. You can change this once you have logged in.