Difference between revisions of "OraSQLPlus"
| (13 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[OracleGettingStarted|Getting Started]] >> SQL*Plus | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[OracleGettingStarted|Getting Started]] >> SQL*Plus | ||
| − | + | == SQL*Plus - First Time == | |
| + | |||
| + | The first time you use SQL*Plus you will need to launch it from the Apps Anywhere Software Hub | ||
== Apps Anyhere == | == Apps Anyhere == | ||
| − | The Oracle database can be accessed via different clients. | + | 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: |
[[http://www.wlv.ac.uk/appsanywhere Apps Anywhere]] | [[http://www.wlv.ac.uk/appsanywhere Apps Anywhere]] | ||
| Line 14: | Line 16: | ||
http://mi-linux.wlv.ac.uk/~oracle/wiki/appsAnywhere.png | 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: | + | Click where it says CLICK HERE and then search for <b>Oracle</b>. It will install as a group of 3 tools: |
| − | + | Oracle Data Modeller<br> | |
| − | + | Oracle SQL Data Developer<br> | |
| − | + | Oracle SQL*Plus | |
| + | |||
| + | Note, you may have to install this for every PC that you use. | ||
| + | == SQL*Plus Client == | ||
| − | Once | + | 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 | http://mi-linux.wlv.ac.uk/~oracle/wiki/oracle_options.png | ||
| Line 29: | Line 34: | ||
Start>All Programs>Oracle >SQL Plus 12.1 | 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: | ||
| + | <table> | ||
| + | <tr><td>User-name:</td><td>This is your student number, preceded by <b>OPS$</b> and followed by <b>@ora12c</b></td></tr> | ||
| + | <tr><td> </td><td> | ||
| + | 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.</td></tr> | ||
| + | <tr><td> </td><td> | ||
| + | <font color="red">Note, the password will not be echoed on the screen, nor any asterisks shown.</font></td></tr> | ||
| + | </table> | ||
Latest revision as of 12:03, 13 January 2016
Main Page >> Oracle and SQL >> Getting Started >> SQL*Plus
SQL*Plus - First Time
The first time you use SQL*Plus you will need to launch it from the Apps Anywhere Software Hub
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. |
