Difference between revisions of "Oracle Getting Started"
| Line 10: | Line 10: | ||
To get started you need to carry out the following steps: | To get started you need to carry out the following steps: | ||
*[[OraRegister|Register for an account]] | *[[OraRegister|Register for an account]] | ||
| − | *[[ | + | *[[Oracle:Apps_Anywhere|Installing SQL*Plus]] |
*[[OraSQLPlus|Using SQL*Plus]] | *[[OraSQLPlus|Using SQL*Plus]] | ||
*[[OraInitial|Setting up the sample database]] | *[[OraInitial|Setting up the sample database]] | ||
Revision as of 12:08, 13 January 2016
Main Page >> Oracle and SQL >> Workbook >> Getting Started
Accessing Oracle using SQL*PLUS
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:
