10SQLU

Introducing Oracle

The Elements of the Oracle System
Relational Concepts

SQL*Plus and SQL Introduction

Logging on to SQL*Plus and Leaving SQL*Plus
Choosing and Describing Tables
Elements of the SQL Query
The SQL Buffer and Query Layout
Editing SQL Statements
The System Dummy Table
Selecting Columns
Duplicate Information (DISTINCT)
Sorting Information

SQL Functions

The Concatenation Operator
Elements of the SQL Query: Arithmetic
Column Aliases
String Functions
Arithmetic Functions
Date Functions
Mixed Functions

Advanced SQL Functions

Nesting Different Functions
SQL Bar Charts
Decode Crosstab
Decode with >, < & =
Select with Minus Union and Intersect
Connect By Prior

Filtering Data Using Where

Where Operators
Where with Keywords
Where and Logical Operators
Where and Soundex

Retrieve Data:Multiple Tables

Joining Tables (Equi-Joins)
Aliases for Table Names
Thinking behind Creating Joins
Joining Tables (Non-Equi-Joins)
Joining Tables (Outer Joins)
Joining Tables (Inner Joins)

Group By Functions

Group By Function Examples
Group By Functions with Having

Sub-Queries

Basic Subqueries
Multiple Column Subqueries
Subqueries with Having
Correlated Subqueries
Subquery Rules and Suggestions

Data Definition Language

Create, Drop Alter Keywords
Tables
Column
Views
Sequences

Data Manipulation Language

Insert
Update
Delete

SQL*Plus Reporting

Introducing SQL*Plus for Reporting
Using SQL*Plus