Difference between revisions of "Oracle"
From mi-linux
Jump to navigationJump to search| Line 8: | Line 8: | ||
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 | + | There will be exercises for you to try out too. In most cases you will be given the results you are aiming for. These will also be presented in a box. |
| + | |||
| + | For example, the results for Exercise 1 are: | ||
Name Null? Type | Name Null? Type | ||
| Line 21: | Line 23: | ||
QTY NUMBER(4) | QTY NUMBER(4) | ||
| − | + | Things to note: | |
| + | <ul> | ||
| + | <li>when running the commands in Oracle you will need to press RETURN after each line</li> | ||
| + | <li>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</li> | ||
| + | </ul> | ||
Menu options (Windows) that involve more than one step will be shown as a sequence, separated by the greater than symbol (>), for example: | Menu options (Windows) that involve more than one step will be shown as a sequence, separated by the greater than symbol (>), for example: | ||
Revision as of 21:23, 15 February 2016
Main Page >> Oracle and SQL
Oracle 12c Version 12.1.0.1.0
The purpose of this handout 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 you are aiming for. These will also be presented in a box.
For example, the results for Exercise 1 are:
Name Null? Type ----------------------------------------- -------- ---------------------------- CNO NUMBER(4) ORDERDATE DATE NAME VARCHAR2(15) CITY VARCHAR2(15) COUNTRY VARCHAR2(15) PNO NUMBER(4) DESCRIPTION VARCHAR2(20) QTY NUMBER(4)
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
