Oracle Workbook

Main Page >> Oracle and SQL >> Workbook

Welcome to the Online Teaching/Learning Resources for Oracle and SQL

This workbook is aimed at students studying their first database module, such as 5CI017, or 7CI006, or as a reminder of how to use Oracle and SQL for advanced database modules.

}

---

Please note the workbook is currently under construction so not fully completed yet. In the meantime an electronic copy of the paper version is usually available in your WOLF topic.

Section 1	1.1 Introduction 1.2 Getting Started using SQL*Plus 1.2.1 Register for an account 1.2.2 Installing SQL*Plus 1.2.3 Using SQL*Plus 1.2.3 Setting up the sample database 1.2.4 Initial queries 1.3 SQL Overview 1.3.1 Setting Environment Variables 1.3.2 How to edit 1.3.3 Getting information from a table 1.3.4 Quitting Oracle 1.3.5 Getting Help and Summary
Section 2	2.1 Saving query output 2.2 Saving and retrieving queries 2.3 Login.sql
Section 3	Data Manipulation Commands (DML) Data Definition Commands (DDL)
Reference Material	Sample Data Set Set up code