Oracle

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 BOLD UPPERCASE:

e.g., 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.

• Workbook
• Useful URLs

If you spot any errors in this workbook, please inform the Oracle DBA: Mary Garvey