Index
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
R
S
T
U
V
W
A
- ALTER statement, B-1
- Arithmetic operators, B-3
B
- BYTE data type, A-1
C
- Case rules, 3-3
- Case studies, 4-1
- CHAR data type, A-1
- COMMIT
- restrictions, 3-8
- Commit point site, 3-7
- Comparison operators, B-3
- Configuring
- two-phase commit, 2-13
- Configuring the gateway, 2-1
- CONNECT BY clause, 3-9
- CREATE statement, B-1
- Creating
- transaction log table, 2-14
- Cursor loops
- restrictions, 3-8
D
- Data definition language, B-1
- Data dictionary
- views, C-2
- Data type
- BYTE, A-1
- CHAR, A-1
- conversion, 3-5
- DATETIME, A-1
- DECIMAL, A-1
- DOUBLE PRECISION, A-1
- FLOAT, A-1
- INTEGER, A-1
- LONG, A-2
- LONG RAW, A-1
- MONEY, A-1
- NCHAR, A-1
- NUMBER, A-1
- NUMERIC, A-1
- NVARCHAR, A-2
- REAL, A-2
- SERIAL, A-2
- SMALLFLOAT, A-2
- SMALLINT, A-2
- TEXT, A-2
- VARCHAR, A-2
- VARCHAR2, A-2
- Database link
- behavior, 2-8
- Date functions, B-5
- DATETIME data type, A-1
- DECIMAL data type, A-1
- DELETE statement, 4-7, B-1, B-2
- restrictions on use, 3-10
- Demo build SQL script, 4-2
- Demonstration files, 4-2
- Demonstration tables, 4-3
- Demonstration tables build SQL script, 4-3
- DOUBLE PRECISION data type, A-1
- DROP statement, B-1
E
- Encrypted format login, 3-11
- Error messages
- error tracing, D-4
- Errors
- ORA-02070, 3-7
F
- FLOAT data type, A-1
G
- Gateway
- case studies, 4-1
- data dictionary tables, C-1
- default SID, 2-1
- pass-through feature, 3-1
- supported functions, B-1
- supported SQL syntax, B-1
- system identifier (SID), 2-1
- two-phase commit, 2-13
- GRANT statement, B-1
- Group functions, B-4
H
- Hexadecimal notation, 3-4
- HS_FDS_RECOVERY_ACCOUNT initialization parameter, D-3
- HS_FDS_RECOVERY_PWD initialization parameter, D-4
- HS_FDS_TRACE_LEVEL initialization parameter, D-4
- HS_FDS_TRANSACTION_LOG initialization parameter, D-4
- HS_FDS_TRANSACTION_MODEL initialization parameter, D-5
- HS_TRANSACTION_LOG, 2-14
I
- Initialization parameter file
- customizing, 2-2, D-1
- initsid.ora file, 2-2, D-1
- INSERT statement, 4-7, B-2
- restrictions on use, 3-10
- INTEGER data type, A-1
K
- Known restrictions, 3-6
L
- listener.ora file, 2-10
- example, 2-4
- location, 2-3
- Locking, database, 3-6
- LONG data type, A-2
- LONG RAW data type, A-1
M
- MONEY data type, A-1
N
- NCHAR data type, 3-8, A-1
- NUMBER data type, A-1
- NUMERIC data type, A-1
- NVARCHAR data type, 3-8, A-2
- NVL function, 4-6
O
- Objects
- valid characters, 3-3
- Objects, naming rules, 3-3
- ORA-02070, 3-7
- Oracle functions
- TO_DATE, B-6
- Oracle Net Services
- configuring, 2-3
P
- Passing commands to database, 3-8
- Pass-Through Feature, 4-7
- Pattern matching, B-4
- PL/SQL, 3-13
R
- RAW data type, 3-4
- REAL data type, 3-8, A-2
- RECOVERY_ACCOUNT
- account username, 2-13
- creating a recovery account, 2-13
- ROLLBACK
- restrictions, 3-8
- ROWID, 3-9, 3-10
S
- savepoint support, 3-7
- SELECT statement, 4-8, B-2, C-1
- use of NULL keyword, 3-9
- SERIAL data type, A-2
- Set operations, B-4
- SID, 2-1
- SMALLFLOAT data type, 3-8, A-2
- SMALLINT data type, A-2
- Stored procedures, 3-11
- String functions, B-4
- SUM function, 4-6
T
- TEXT data type, A-2
- TNS listener
- configuring for gateway, 2-3
- starting, 2-5
- TO_DATE function, B-6
- Transaction log table
- creating, 2-14
- transactional capability, 3-7
- transactional integrity, 3-7
- TRUNCATE statement, B-1
- Two-phase commit, 3-7
- configuration, 2-13
- transaction log table, 2-14
U
- UPDATE statement, 4-7, B-2
- restrictions on use, 3-9, 3-10
V
- VARCHAR data type, A-2
- VARCHAR2 data type, A-2
W
- WHERE CURRENT OF clause, 3-9
