Difference between revisions of "Oracle:SQLPlus"
From mi-linux
Jump to navigationJump to search| Line 19: | Line 19: | ||
</table> | </table> | ||
| − | Do note that the password is case sensitive, but the user-name is not. Generally the password | + | Do note that the password is <b>case sensitive</b>, 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 <b>SQL></b> prompt: | ||
| + | |||
| + | http://mi-linux.wlv.ac.uk/~oracle/wiki/SQLPlus_Client2.png | ||
Revision as of 13:40, 13 January 2016
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:
