Difference between revisions of "Oracle"

From mi-linux
Jump to navigationJump to search
Line 12: Line 12:
 
Note, when running the commands in Oracle you will need to press RETURN after each line.
 
Note, when running the commands in Oracle you will need to press RETURN after each line.
  
Menu options 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:
  
 
   File>Open
 
   File>Open
  
Means select File from the main Window menu then Open from the submenu
+
Means select <b>File</b> from the main Window menu then <b>Open</b> from the submenu
  
 
* [[Oracle_Workbook|Workbook]]
 
* [[Oracle_Workbook|Workbook]]

Revision as of 12:34, 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.

Note, when running the commands in Oracle you will need to press RETURN after each line.

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