Difference between revisions of "Oracle Getting Started"
(Created page with " <h2>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 f...") |
|||
| Line 1: | Line 1: | ||
| − | <h2>Accessing Oracle using SQL*PLUS</h2> | + | <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. | 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. | ||
Revision as of 09:38, 11 January 2016
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.
Before you can use Oracle you need to first register for an account:
