Oracle 10 G

ORACLE 10g Lab Guide
A supplement to: Database Systems: Design, Implementation and Management
(International Edition) Rob, Coronel & Crockett (ISBN: 9781844807321)

ORACLE 10g Lab Guide

Table of Contents

Lab 1 2 3 4 5 6 7 8 9 10

Title Introduction to ORACLE 10g interfaces Creating a small database from a script file Data Manipulation Commands Basic SELECT statements Advanced SELECT statements Joining Tables SQL functions Set operators Subqueries Views

Page 4 21 37 48 64 77 94 114 121 133

Keeley Crockett

2

ORACLE 10g Lab Guide

Introduction to the ORACLE 10g Lab Guide
This lab guide is designed to provide examples and exercises in the fundamentals of SQL within the ORACLE 10g environment. The objective is not to develop full blown applications but to illustrate the concepts of SQL using simple examples. The lab guide has been divided up into 10 sessions. Each one comprises of examples, tasks and exercises about a particular concept in SQL and how it is implemented in ORACLE 10g. On completion of this 10 week lab guide you will be able to: • • • • • • • • Create a simple relational database in ORACLE 10g Insert, update and delete data the tables Create queries using basic and advanced SELECT statements Perform join operations on relational tables Apply set operators Use aggregate functions in SQL Write subqueries Create views of the database

This lab guide assumes that you know how to perform basic operations in the Microsoft Windows environment. Therefore, you should know what a folder is, how to maximize or minimize a folder, how to create a folder, how to select a file, how you maximize and minimize windows, what clicking and double-clicking indicate, how you create a folder, how you drag, how to use drag and drop, how you save a file, and so on.

Keeley Crockett

3

ORACLE 10g Lab Guide The lab guide has been designed on ORACLE 10g version 10.2.0.1.0 running on Windows XP Professional. Before starting this guide, you must