Index

A  B  C  D  E  F  G  I  L  M  O  P  R  S  T  U  V  W 

---

A

accessing remote databases, 4-1

AFTER triggers, 3-1

alias, 2-19

application development tools, 4-4

arithmetic operators, 2-110

ARRAY FETCH, 3-11

ASSIGNMENT statement, 3-55

---

B

BEGIN TRAN statement, 3-14

BEGIN TRANSACTION statement, 3-14

bit operators, 2-111

BLOBs, 2-6

built-in functions, 2-112, 3-80

byte-stream, 3-4

---

C

Capture Wizard, 1-3

changing NULL constructs, 2-109

CHAR(n) data type, 2-10

character functions, 2-112

check constraints, 2-7

column aliases, 3-62

column names, 2-3

column-level CHECK constraint, 2-7

COMMIT TRAN statement, 3-14

COMMIT TRANSACTION statement, 3-14

comparison operators, 2-106

connecting to a database, 2-94

control files, 2-18

converting multiple result sets, 3-12

CREATE PROCEDURE statement, 3-39

cursor handling, 3-70

cursor variables, 3-4

cursor variables, return query results, 3-10

customized error messages, 3-16

---

D

data and hash cluster, 2-33

data block, 2-14

data concurrency, 2-118

data manipulation language, 2-93

data storage concepts, 2-13

data type mappings, 2-8

data types, 3-16

data types, conversion considerations, 2-3

database, 2-21

database devices, 2-14

database link, 2-31

datafiles, 2-14

date functions, 2-115

DATETIME data type, 2-3, 2-11

DB-Library code, 3-6

DDL constructs, 3-84

declarative referential integrity, 2-7

DECLARE statement, 3-41

defaults, 2-39

DELETE statement, 2-105

DELETE triggers, 3-2

DELETE with FROM statement, 3-65

destination database, 1-3

distributed environments, 4-1

---

E

emulate temporary tables, 5-7

entity integrity constraints, 2-6

error handling, 3-15

error-handling semantics, 3-77

exception-handling semantics, 3-77

EXECUTE statement, 3-48

explicit transaction model, 3-73

extent, 2-14

---

F

features, 1-2

FETCH request, 3-4

FLOAT data type, 2-9

function, schema object, 3-25

functions, defining in Oracle, 2-114

---

G

GOTO statement, 3-53

---

I

IF statement, 3-42

IMAGE data type, 2-6

implicit transaction model, 3-73

IN OUT parameter, 3-10

individual SQL statements, 3-13

INSERT statement, 2-102

INSERT triggers, 3-2

---

L

locking concepts, 2-118

logical transaction, 3-14

logical transaction handling, 2-122

---

M

maintenance of temporary tables, 5-10

mathematical functions, 2-117

Migrating, 5-1

Migration Wizard, 1-3

miscellaneous functions, 2-114

multiple queries, 5-5

multiple result sets, 3-80

multiple results sets, 3-12

multi-row array, 3-7

multi-row query, 3-10

multi-table joins, performance, 5-4

---

O

object names, 2-3

ODBC, 3-5

operators, 2-106, 3-80

Oracle Model, 1-3

output variables, 3-4

---

P

package body, 3-33

package, schema object, 3-29

page, 2-14

page-level locking, 2-120

parameter passing, 3-40

permanent tables, 5-8

PL/SQL and T-SQL constructs, comparison, 3-37

PL/SQL and T-SQL, language elements, 3-73

PL/SQL tables as output variables, 3-7

privilege, 2-46

procedure, schema object, 3-18

product description, 1-1

profile, 2-51

---

R

RAISERROR statement, 3-15, 3-47

read consistency, 2-121

redo log files, 2-16

referential integrity, 3-2

referential integrity constraints, 2-6

remote objects, Oracle, 4-2

remote objects, SQL Server and Sybase, 4-2

replace temporary tables, 5-7

replication, 4-3

repository, 1-3

reserved words, 2-3

result set with multiple rows, 3-6

result set, converted using cursor variable, 3-68

result sets, 3-4

RETURN statement, 3-46

role, 2-55

ROLLBACK TRAN statement, 3-14

ROLLBACK TRANSACTION statement, 3-14

row-level locking, 2-120

rule, 2-60

---

S

schema migration, 2-1

schema object similarities, 2-1

schema objects, comparison, 2-18

segments, 2-14

SELECT INTO statement, 2-98

SELECT statement, 2-95, 3-56

SELECT statement, part of SELECT list, 3-59

SELECT statement, result sets, 3-7

SELECT statement, with GROUP BY clause, 3-61

SELECT statements without FROM clauses, 2-98

SELECT with GROUP BY statement, 2-101

sequence, 2-62

set operators, 2-111

single result set, 3-80

snapshot, 2-65

source database, 1-3

Source Model, 1-3

special global variables, 3-78

stored procedures, SQL Server, 3-1

stored subprograms, Oracle, 3-1

string operators, 2-110

subqueries, 2-100

SYSNAME data type, 2-12

---

T

table design considerations, 2-3

table-level CHECK constraint, 2-7

tables, 2-69

tablespace, 2-15, 2-80

temp_table_catalog, definition, 5-11

temporary table usage, 5-1

temporary tables in Oracle8i, 5-9

temporary tables, comparison, 3-67

temporary tables, creating dynamically, 5-7

temporary tables, emulate, 5-7

temporary tables, maintenance, 5-10

temporary tables, replace, 5-7

TEXT data type, 2-6

TIMESTAMP data type, 2-12

transaction handling semantics, 3-73

transaction handling statements, 3-72

triggers, Oracle, 3-1

triggers, SQL Server, 3-1

T-SQL and PL/SQL constructs, comparison, 3-37

T-SQL and PL/SQL, language elements, 3-73

T-SQL local variables, 3-16

---

U

unique keys, 2-7

UPDATE statement, 2-103

UPDATE triggers, 3-2

UPDATE with FROM statement, 3-63

user, 2-84

user-defined types, SQL Server, 2-6

---

V

VARCHAR(n) data type, 2-10

view, 2-88

---

W

WHILE statement, 3-49