Difference between revisions of "OraSQLPlus"
| Line 38: | Line 38: | ||
Fill in the following, note the format of the username carefully: | Fill in the following, note the format of the username carefully: | ||
<table border="1"> | <table border="1"> | ||
| − | <tr><td>User-name:</td><td>This is your student number, preceded by OPS$ and followed by @ora12c<br> | + | <tr><td>User-name:</td><td>This is your student number, preceded by <b>OPS$</b> and followed by <b>@ora12c</b><br> |
E.g., if your username is 0912345, then type in: OPS$0912345@ora12c</td></tr> | E.g., if your username is 0912345, then type in: OPS$0912345@ora12c</td></tr> | ||
<tr><td>Password:</td><td>When you registered for Oracle, you will have been given a password. Type this in when prompted. <br> | <tr><td>Password:</td><td>When you registered for Oracle, you will have been given a password. Type this in when prompted. <br> | ||
<font color="red">Note, the password will not be echoed on the screen, nor any asterisks shown.</font></td></tr> | <font color="red">Note, the password will not be echoed on the screen, nor any asterisks shown.</font></td></tr> | ||
</table> | </table> | ||
Revision as of 20:54, 11 January 2016
Main Page >> Oracle and SQL >> Getting Started >> SQL*Plus
SQL*Plus
Apps Anyhere
The Oracle database can be accessed via different clients. When using the software at the University, it is available via the Applications Anywhere software hub: [Apps Anywhere]
The first time you use Oracle, click the Apps Anywhere icon on your desktop:
http://mi-linux.wlv.ac.uk/~oracle/wiki/Apps.png
Which will bring up the following window:
http://mi-linux.wlv.ac.uk/~oracle/wiki/appsAnywhere.png
Click where it says CLICK HERE and then search for Oracle. It will install as a group of 3 tools:
Oracle Data Modeller
Oracle SQL Data Developer
Oracle SQL*Plus
Note, you may have to install this for every PC that you use.
SQL*Plus Client
Once SQL*Plus has been installed you should find it has been added to your program menu (or select from new window - check):
http://mi-linux.wlv.ac.uk/~oracle/wiki/oracle_options.png
In which case you can start the program by clicking on:
Start>All Programs>Oracle >SQL Plus 12.1
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. |
