Index
A
B
C
D
E
F
G
H
I
K
L
N
O
P
R
S
T
U
V
W
A
- ALTER statement, B-1
- Arithmetic operators, B-3
B
- BYTE data type, A-1
- BYTEINT data type, A-1
C
- Case rules, 3-3
- Case studies, 4-1
- CHAR data type, A-1
- CHARACTER data type, A-1
- COMMIT
- restrictions, 3-7
- Commit point site, 3-7
- Comparison operators, B-3
- Configuring
- two-phase commit, 2-11
- Configuring the gateway, 2-1
- CONNECT BY clause, 3-9
- COPY command, 3-9
- CREATE statement, B-1
- Creating
- transaction log table, 2-12
- Cursor loops
- restrictions, 3-7
D
- Data definition language, B-1
- Data dictionary
- views, C-2
- Data type
- BYTE, A-1
- BYTEINT, A-1
- CHAR, A-1
- CHARACTER, A-1
- conversion, 3-5
- DATE, A-1
- DEC, A-1
- DECIMAL, A-1
- DOUBLE PRECISION, A-1
- FLOAT, A-1
- INT, A-1
- INTEGER, A-1
- INTERVAL, A-1
- LONG, A-2
- LONG VARCHAR, A-2
- NUMBER, A-1
- NUMERIC, A-2
- RAW, A-1
- REAL, A-2
- SMALLINT, A-2
- TIME, A-2
- TIMESTAMP, A-2
- VARBINARY, 3-10
- VARBYTE, A-2
- VARCHAR, A-2
- VARCHAR2, A-2
- Database link
- behavior, 2-7
- DATE data type, A-1
- DDL statement, 3-8
- DEC data type, A-1
- DECIMAL data type, A-1
- DELETE statement, 4-6, B-1, B-2
- 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-10
- 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-11
- GRANT statement, B-1
- Group functions, B-4
H
- Hexadecimal notation, 3-4
- HS_FDS_CONNECT_INFO initialization parameter, D-3
- 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-12
I
- Initialization parameter file
- customizing, 2-2, D-1
- initsid.ora file, 2-2, D-1
- INSERT statement, 4-7, B-1, B-2
- INT data type, A-1
- INTEGER data type, A-1
- INTERVAL data type, A-1
K
- Known restrictions, 3-6
L
- listener.ora file, 2-9
- example, 2-4
- location, 2-3
- Locking, database, 3-6
- LONG data type, A-2
- LONG VARCHAR data type, A-2
N
- NUMBER data type, A-1
- NUMERIC data type, A-2
- NVL function, 4-6
O
- Objects, naming rules, 3-3
- ORA-02070, 3-7
- Oracle Net Services
- configuring, 2-2
P
- Passing commands to database, 3-8
- Pass-Through Feature, 4-7
- PL/SQL, 3-12
R
- RAW data type, A-1
- REAL data type, A-2
- RECOVERY_ACCOUNT
- account username, 2-12
- creating a recovery account, 2-12
- ROLLBACK
- restrictions, 3-7
- ROWID, 3-9
S
- savepoint support, 3-7
- SELECT statement, 4-7, B-2, C-1
- SID, 2-1
- SMALLINT data type, A-2
- Stored procedures, 3-10
- String functions, B-4
- SUM function, 4-6
T
- TIME data type, A-2
- TIMESTAMP data type, A-2
- TNS listener
- configuring for gateway, 2-3
- starting, 2-5
- Transaction log table
- creating, 2-12
- transactional capability, 3-7
- transactional integrity, 3-7
- TRUNCATE statement, B-1
- Two-phase commit, 3-7
- configuration, 2-11
- transaction log table, 2-12
U
- UPDATE statement, 3-9, 4-6, 4-7, B-2
V
- VARBINARY data type, 3-10
- VARBYTE data type, A-2
- VARCHAR data type, A-2
- VARCHAR2 data type, A-2
W
- WHERE CURRENT OF clause, 3-9
