Difference between revisions of "OraSQLPlus"

From mi-linux
Jump to navigationJump to search
 
(24 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
−
<h2 "style=color:blue">SQL*Plus</h2>
+
== SQL*Plus - First Time ==
  
−
The Oracle database can be accessed via different clients. If using Oracle at the University the software is available via the Applications Anywhere software hub:
+
The first time you use SQL*Plus you will need to launch it from the Apps Anywhere Software Hub
−
http://www.wlv.ac.uk/appsaywhere
 
  
−
The first time you use Oracle, go to the Apps Anywhere icon on your desktop:  
+
== Apps Anyhere ==
−
[[http://mi-linux.wlv.ac.uk/~oracle/wiki/appsAnywhere.png Apps Anywhere]]
+
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]]
  
−
and click where it says CLICK HERE.
+
The first time you use Oracle, click the Apps Anywhere icon on your desktop:
  
 +
http://mi-linux.wlv.ac.uk/~oracle/wiki/Apps.png
  
−
[[Image:/home/oracle/public_html/wiki/appsAnywhere.png|100px|Apps Anywhere]]
+
Which will bring up the following window:
  
−
<gallery widths=60px heights=60px perrow=7 caption="sunflowers are groovy">
+
http://mi-linux.wlv.ac.uk/~oracle/wiki/appsAnywhere.png  
−
file:/home/oracle/public_html/wiki/appsAnywhere.png
 
−
</gallery>
 
  
 +
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.
 
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:
 +
<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>&nbsp;</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>&nbsp;</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.
Retrieved from "https://mi-linux.wlv.ac.uk/wiki/index.php?title=OraSQLPlus&oldid=8451"