Oracle Rdb(tm) A Comparison of SQL Dialects for Oracle and Oracle Rdb

Contents

Send Us Your Comments vii

Preface ix

1 Data Model

1.1 Schemas

1.1.1 Tables

1.1.2 Constraints

1.1.3 Domains

1.1.4 Sequences

1.1.5 Synonyms

1.1.6 Triggers

1.1.7 Views

1.2 Database Link

1.3 Nonschema Objects

1.4 Distributed Data

1.5 Namespaces

1.6 Data Types

1.6.1 Character Data Types

1.6.2 Numeric Data Types

1.6.3 Date-Time Data Types

1.6.4 Bit String Data Types

1.6.5 Long Data Types

1.6.6 Other Data Types

1.7 Multinational Character Sets

2 Data Operations

2.1 Operators

2.2 Concatenation

2.3 Conversions

3 Lexical Issues

3.1 SQL Names

3.2 Qualified Names

3.2.1 Qualified Table Names

3.2.2 Qualified Column Names

3.3 Comment Indicators

3.4 "Not equals" Operators

3.5 Outer Join (+)

3.6 Reserved Words and Keywords

4 Query Specifications

4.1 Pseudocolumns

4.1.1 Row Addresses (ROWID and DBKEY)

4.1.2 Number of Rows Returned (ROWNUM)

4.1.3 Values of Sequences (NEXTVAL and CURRVAL)

4.1.4 Recursive Unions (LEVEL)

4.2 Functions

4.2.1 DECODE Function

4.2.2 CASE Expression

4.3 Predicates

4.4 Select Expression

4.4.1 SELECT List

4.4.2 Derived Tables

4.4.3 Scope of Table Names

4.4.4 ORDER BY Clause

4.4.5 GROUP BY Clause

5 Data Manipulation

5.1 Database Attachments

5.2 Subqueries (UPDATE, DELETE and INSERT)

5.3 UPDATE Statement

5.3.1 Set Single or Multiple Columns (SET Clause)

5.3.2 Mix Values and Subqueries (UPDATE and INSERT Statements)

5.3.3 Bulk Updates on a Column with a UNIQUE Constraint

5.3.4 Correlated Subqueries

5.4 DELETE [FROM] Table

6 Data Definition Statements

6.1 Data Definition Language and Transactions

6.2 Data Type Usage (CREATE TABLE, CREATE DOMAIN, Declare Variable)

6.2.1 Data Type Synonyms

6.2.2 Data Type Defaults

6.3 Table Creation (CREATE TABLE ... AS SELECT)

6.4 Table Alterations (ALTER TABLE)

6.5 Constraints

6.5.1 Referential Delete (ON DELETE CASCADE)

6.5.2 Unique Indexes (UNIQUE or PRIMARY KEY)

6.5.3 Constraint Exceptions (EXCEPTIONS INTO)

6.5.4 Disabled and Enabled Constraints (DISABLE, ENABLE)

6.5.5 Deferred Constraints

6.6 CREATE OR REPLACE Clause for Compiled Objects

6.7 CREATE VIEW Statement

6.8 Add Comments to Describe Metadata or Data Definitions (COMMENT ON)

6.9 Delete Definitions (DROP ... CASCADE)

6.10 Object Recompilation (ALTER FUNCTION, ALTER TRIGGER, ALTER VIEW, ALTER PROCEDURE)

6.11 Rename Database Objects (RENAME)

A Reserved Words