List of Code Examples

Chapter 4: Creating RDBMS Objects

Listing 4-1: Default (NO ACTION) option

Listing 4-2: CASCADE option

Listing 4-3: Using deferrable constraints

Chapter 5: Altering and Destroying RDBMS Objects

Oracle 9i

DB2 UDB 8.1

MS SQL Server 2000

Oracle 9i

DB2 UDB 8.1

Chapter 9: Multitable Queries

SQL99 standard syntax

Old syntax

Syntax for right outer join

Syntax for left outer join

Syntax for right outer join

Syntax for left outer join

Chapter 14: Stored Procedures, Triggers, and User-Defined Functions

PL/SQL

DB2 UDB

Transact-SQL

SQL99

PL/SQL

DB2 procedural language

Transact-SQL

SQL99

PL/SQL

DB2 procedural language

Transact-SQL

Chapter 15: Dynamic and Embedded SQL Overview

Example 1

Example 2

Example 3

Oracle example

DB2 UDB example

C

COBOL

C

COBOL

C

COBOL

C

COBOL

C

COBOL

C

COBOL

C

COBOL

PREPARE

EXECUTE

C

COBOL

C

COBOL

Appendix H: SQL Syntax Reference

"New" syntax (inner join)

"New" syntax (outer join)

"Old" syntax (inner join)