Difference between revisions of "Oracle Getting Started"
m (Protected "Oracle Getting Started" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
<h2 style="color:blue">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 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. |
| − | You will use Oracle | + | You will use Oracle in a 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 SQL*Plus program which you will use to talk to it is located on the University's Windows labs. |
| − | + | SQL*Plus 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 (mi-linux.wlv.ac.uk/csl-student.wlv.ac.uk) using a secure shell (SSH) program, such as Putty and the Linux command line interface. | |
To get started you need to carry out the following steps: | To get started you need to carry out the following steps: | ||
*[[Oracle:Register|Register for an account]] | *[[Oracle:Register|Register for an account]] | ||
*[[Oracle:Apps_Anywhere|Installing SQL*Plus]] | *[[Oracle:Apps_Anywhere|Installing SQL*Plus]] | ||
| − | *[[ | + | *[[Oracle:SQLPlus|Using SQL*Plus]] |
| − | *[[ | + | *[[Oracle:Sample_Database|Setting up the sample database]] |
| + | *[[Oracle:Initial_Queries|Initial queries]] | ||
| + | |||
| + | == Next Step == | ||
| + | |||
| + | Once you have completed these steps return to the [[Oracle_Workbook|Workbook]] for the next section. | ||
Latest revision as of 15:44, 24 February 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.
You will use Oracle in a 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 SQL*Plus program which you will use to talk to it is located on the University's Windows labs.
SQL*Plus 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 (mi-linux.wlv.ac.uk/csl-student.wlv.ac.uk) using a secure shell (SSH) program, such as Putty and the Linux command line interface.
To get started you need to carry out the following steps:
- Register for an account
- Installing SQL*Plus
- Using SQL*Plus
- Setting up the sample database
- Initial queries
Next Step
Once you have completed these steps return to the Workbook for the next section.
