OraSQLPlus

From mi-linux
Jump to navigationJump to search

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.