Difference between revisions of "Oracle"
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Main Page]] >> Oracle and SQL | [[Main Page]] >> Oracle and SQL | ||
| − | + | == Oracle 19c Version 19.3.0.0.0== | |
| − | The purpose of this | + | |
| + | From the 2019/20 Academic year we will be using Oracle 19c. | ||
| + | |||
| + | Oracle 12c should only be used by MSc students who are completing their projects. | ||
| + | |||
| + | The purpose of this Wiki is to introduce using SQL from the Oracle database management system (DBMS). It is intended to be supplemented by a lecture course. | ||
Commands to try out are in a box, for example: | Commands to try out are in a box, for example: | ||
| − | + | SELECT * FROM DEPT; | |
| − | SELECT * FROM DEPT; | ||
| − | |||
| − | |||
| − | |||
| − | + | There will be exercises for you to try out too. In most cases you will be given the results so you can check your answer. These will also be presented in a blue font, for example: | |
<pre style="color: blue"> | <pre style="color: blue"> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | DEPTNO DNAME LOC | ||
| + | ---------- -------------- ------------- | ||
| + | 10 ACCOUNTING NEW YORK | ||
| + | 20 RESEARCH DALLAS | ||
| + | 30 SALES CHICAGO | ||
| + | 40 OPERATIONS BOSTON | ||
</pre> | </pre> | ||
Things to note: | Things to note: | ||
| − | + | *when running the commands in Oracle you will need to press RETURN after each line. | |
| − | + | *the order of the results may differ from yours. The key thing is that you have the same rows, but not necessarily in the same order. | |
| − | |||
| − | |||
Latest revision as of 11:15, 1 October 2019
Main Page >> Oracle and SQL
Oracle 19c Version 19.3.0.0.0
From the 2019/20 Academic year we will be using Oracle 19c.
Oracle 12c should only be used by MSc students who are completing their projects.
The purpose of this Wiki is to introduce using SQL from the Oracle database management system (DBMS). It is intended to be supplemented by a lecture course.
Commands to try out are in a box, for example:
SELECT * FROM DEPT;
There will be exercises for you to try out too. In most cases you will be given the results so you can check your answer. These will also be presented in a blue font, for example:
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
Things to note:
- when running the commands in Oracle you will need to press RETURN after each line.
- the order of the results may differ from yours. The key thing is that you have the same rows, but not necessarily in the same order.
Menu options (Windows) that involve more than one step will be shown as a sequence, separated by the greater than symbol (>), for example:
File>Open
Means select File from the main Window menu then Open from the submenu
If you spot any errors in this workbook, please inform the Oracle DBA: Mary Garvey
