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.1
AFTER triggers, 3.1
application development tools, 4.2
arithmetic operators, 2.4.7.2
ASSIGNMENT statement, 3.5.11

B

BEGIN TRAN statement, 3.2.2
BEGIN TRANSACTION statement, 3.2.2
bit operators, 2.4.7.5
BLOBs, 2.1.3.1.2
built-in functions, 2.4.8, 3.6.5

C

CHAR(n) data type, 2.2.1
character functions, 2.4.8.1
check constraints, 2.1.3.5
column aliases, 3.5.14
column names, 2.1.2
column-level CHECK constraint, 2.1.3.5
COMMIT TRAN statement, 3.2.2
COMMIT TRANSACTION statement, 3.2.2
comparison operators, 2.4.7.1
connecting to a database, 2.4.1
control files, 2.3.1
CREATE PROCEDURE statement, 3.5.1
cursor handling, 3.5.18
customized error messages, 3.2.3.2

D

data block, 2.3.1
data concurrency, 2.4.9
data files, 2.3.1
data manipulation language, 2.4
data storage concepts, 2.3
data type mappings, 2.2
data types, 3.3
data types, conversion considerations, 2.1.3.1
database devices, 2.3.1
date functions, 2.4.8.3
DATETIME data type, 2.1.3.1.1, 2.2.1
DDL constructs, 3.6.6
declarative referential integrity, 2.1.3.3
DECLARE statement, 3.5.3
DELETE statement, 2.4.6
DELETE triggers, 3.1
DELETE with FROM statement, 3.5.16
destination database, 1.4
Disconnected Source Model Load, 5
distributed environments, 4.1

E

entity integrity constraints, 2.1.3.2
error handling, 3.2.3
error-handling semantics, 3.6.2
exception-handling semantics, 3.6.2
EXECUTE statement, 3.5.7
explicit transaction model, 3.6.1
extent, 2.3.1

F

features, 1.3
Flat File Generation Scripts, 5.1.1
FLOAT data type, 2.2.1
function, schema object, 3.4.2
functions, defining in Oracle, 2.4.8.2.1

G

global variables, 3.5.10, 3.6.3
GOTO statement, 3.5.9

I

IF statement, 3.5.4
IMAGE data type, 2.1.3.1.2
implicit transaction model, 3.6.1
individual SQL statements, 3.2.1
INSERT statement, 2.4.4
INSERT triggers, 3.1

L

locking concepts, 2.4.9
logical transaction, 3.2.2
logical transaction handling, 2.4.9.4

M

mathematical functions, 2.4.8.4
metadata flat files
generating, 5.1
miscellaneous functions, 2.4.8.2

O

object names, 2.1.2
operators, 2.4.7, 3.6.4
Oracle Model, 1.4

P

package body, 3.4.4
package, schema object, 3.4.3
page, 2.3.1
page-level locking, 2.4.9.2
parameter passing, 3.5.2
PL/SQL and T-SQL constructs, comparison, 3.5
PL/SQL and T-SQL, language elements, 3.6
procedure, schema object, 3.4.1
product description, 1.2

R

RAISERROR statement, 3.2.3.1, 3.5.6
read consistency, 2.4.9.3
redo log files, 2.3.1
referential integrity, 3.1
referential integrity constraints, 2.1.3.3
remote objects, Oracle, 4.1.1.1
remote objects, SQL Server or Sybase, 4.1.2
replication, 4.1.3
repository, 1.4
reserved words, 2.1.2
RETURN statement, 3.5.5
ROLLBACK TRAN statement, 3.2.2
ROLLBACK TRANSACTION statement, 3.2.2
row-level locking, 2.4.9.2

S

schema migration, 2.1
schema object similarities, 2.1.1
SELECT INTO statement, 2.4.2.2
SELECT statement, 2.4.2, 3.5.12
SELECT statement, with GROUP BY clause, 3.5.13
SELECT statements without FROM clauses, 2.4.2.1
SELECT with GROUP BY statement, 2.4.3
set operators, 2.4.7.4
source database, 1.4
Source Model, 1.4
special global variables, 3.6.3
stored procedures, SQL Server or Sybase, 3.2
stored subprograms, Oracle, 3.2
string operators, 2.4.7.3
SYSNAME data type, 2.2.1

T

table design considerations, 2.1.3
table-level CHECK constraint, 2.1.3.5
tablespace, 2.3.1
temporary tables, comparison, 3.5.17
TEXT data type, 2.1.3.1.2
TIMESTAMP data type, 2.2.1
transaction handling semantics, 3.6.1
triggers, Oracle, 3.2
triggers, SQL Server or Sybase, 3.2
T-SQL and PL/SQL constructs, comparison, 3.5
T-SQL and PL/SQL, language elements, 3.6
T-SQL local variables, 3.3.1

U

unique keys, 2.1.3.4
UPDATE statement, 2.4.5
UPDATE triggers, 3.1
UPDATE with FROM statement, 3.5.15
user-defined types, SQL Server or Sybase, 2.1.3.1.3

V

VARCHAR(n) data type, 2.2.1

W

WHILE statement, 3.5.8