View source for Oracle Getting Started

[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> Getting Started
<h2 style="color:blue">Accessing Oracle using SQL*PLUS</h2>

The DBMS software used in several database modules is known as Oracle and is supplied by the Oracle Corporation. Oracle is a fully featured multi-user database designed for large-scale applications. The main feature of Oracle that you will use is the SQL interface known as SQL*Plus.

You will use Oracle mainly in client-server mode. That means that you will use a Windows client program to communicate with Oracle that is situated on a Linux server. The database and the database management system are stored on machine called oradb-srv, the program which you will use to talk to it is located on the University's Windows labs.

The advantage of this arrangement is that it will allow you to use familiar Windows commands to enter and edit your SQL commands.  The client software is available in all the MI Labs, or in the Learning Centre labs that have the computing image. Alternatively, it is possible to use SQL*Plus from the student Linux server (csl-student.wlv.ac.uk) using a secure shell (SSH) program and the Linux command line interface. 

To get started you need to carry out the following steps:
*[[Oracle:Register|Register for an account]]
*[[Oracle:Apps_Anywhere|Installing SQL*Plus]]
*[[OraSQLPlus|Using SQL*Plus]]
*[[OraInitial|Setting up the sample database]]