More SQL

Table of Contents

More SQL

Defining a Database Schema

Defining a Database Schema (II)

Example

Types

Types (II)

Oracle Default Dates (Used at Stanford)

Oracle Default Dates (II)

Declaring Keys

Declaring Keys (II)

Declaring Keys (III)

Example

INFO

Example

Other Properties You Can Give to Attributes

Example

Example (II)

Example (III)

Changing Columns

Views

Views (II)

Example

Querying Views

Semantics of View Use

Semantics of View Use (II)

Compose

Optimize Query

Optimize Query (II)

Nulls

Comparing Nulls to Values

Example

3-Valued Logic

Some Key Laws Fail to Hold

Email: burt@umbc

Home Page: www.cs.umbc.edu/~burt