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-109
- ARRAY FETCH, 3-11
- ASSIGNMENT statement, 3-53
B
- BEGIN TRAN statement, 3-14
- BEGIN TRANSACTION statement, 3-14
- bit operators, 2-111
- BLOBs, 2-5
- built-in functions, 2-112, 3-78
- 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-60
- 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-37
- cursor handling, 3-68
- 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-82
- declarative referential integrity, 2-6
- DECLARE statement, 3-39
- defaults, 2-39
- DELETE statement, 2-104
- DELETE triggers, 3-2
- DELETE with FROM statement, 3-63
- 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-75
- exception-handling semantics, 3-75
- EXECUTE statement, 3-46
- explicit transaction model, 3-71
- extent, 2-14
F
- features, 1-2
- FETCH request, 3-4
- FLOAT data type, 2-9
- function, schema object, 3-24
- functions, defining in Oracle, 2-114
G
- global variables, 3-52, 3-76
- GOTO statement, 3-51
I
- IF statement, 3-40
- IMAGE data type, 2-5
- implicit transaction model, 3-71
- 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
- Migration Wizard, 1-3
- miscellaneous functions, 2-114
- multiple queries, 5-5
- multiple result sets, 3-79
- 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-78
- Oracle Model, 1-3
- output variables, 3-4
P
- package body, 3-32
- package, schema object, 3-28
- page, 2-14
- page-level locking, 2-120
- parameter passing, 3-38
- permanent tables, 5-8
- PL/SQL and T-SQL constructs, comparison, 3-35
- PL/SQL and T-SQL, language elements, 3-71
- 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-45
- 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-4
- reserved words, 2-3
- result set with multiple rows, 3-6
- result set, converted using cursor variable, 3-66
- result sets, 3-4
- RETURN statement, 3-44
- 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-54
- SELECT statement, part of SELECT list, 3-57
- SELECT statement, result sets, 3-7
- SELECT statement, with GROUP BY clause, 3-59
- 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-78
- snapshot, 2-65
- source database, 1-3
- Source Model, 1-4
- special global variables, 3-76
- 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-68
- 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-65
- 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-5
- TIMESTAMP data type, 2-12
- transaction handling semantics, 3-71
- transaction handling statements, 3-70
- triggers, Oracle, 3-1
- triggers, SQL Server, 3-1
- T-SQL and PL/SQL constructs, comparison, 3-35
- T-SQL and PL/SQL, language elements, 3-71
- T-SQL local variables, 3-16
U
- unique keys, 2-7
- UPDATE statement, 2-102
- UPDATE triggers, 3-2
- UPDATE with FROM statement, 3-61
- user, 2-84
- user-defined types, SQL Server, 2-6
V
- VARCHAR(n) data type, 2-10
- view, 2-88
W
- WHILE statement, 3-47