Difference between revisions of "Oracle:SQLPlus"

Revision as of 13:17, 13 January 2016

Once SQL*Plus has been installed you should find it has been added to your program menu (or select from new window - check):

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:

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.

@@ Line 1: / Line 1: @@
-[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[OracleGettingStarted|Getting Started]] >> SQL*Plus
+[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Getting_Started|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:
-[[http://www.wlv.ac.uk/appsanywhere 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 <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 ==