Oracle:SQLPlus

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 initial password given starts with a capital letter. You can change this once you have logged in.

If you have logged in successfully you will be presented with the SQL> prompt:

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

SQL*Plus Command Line

The prompt SQL> means the system is waiting for you to enter a command.

There are two types of command that you may enter:

• SQL commands. For manipulating data in the database. Each SQL command is terminated by a semi-colon, which will be seen later.

• Control commands. For formatting results and editing. The semi-colon is optional for these commands.

Changing Your Password

It is advisable to change your initial password to something else. To do this, once you have logged in, type:

 password

It will ask for your old password first, before you can set a new one.

If you forget your new password and the system locks you out, re-run the registration program and it will reset it back to the original password for you (we can not recreate the updated password!):

https://mi-linux.wlv.ac.uk/~oracle/reg12c/orareg.php

Next: Setting up the Sample Database

Initially you will have no tables in your database. The next step is to setup the sample database: Oracle:Sample_database