Index
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
R
S
T
U
V
W
Symbols
- ||, 3-11
A
- ALTER statement, B-1
- Arithmetic operators, B-3
B
- BYTE data type, A-1
- BYTE VARYING data type, A-1
C
- C data type, A-1
- Case rules, 3-3
- Case studies, 4-1
- CHAR data type, A-1
- COLUMN_VALUE_LONG function, 3-7
- COMMIT
- restrictions, 3-7
- Comparison operators, B-3
- CONCAT operator, 3-11
- Configuring
- two-phase commit, 2-13
- Configuring the gateway, 2-1
- CONNECT BY clause, 3-8
- COPY command, 3-9
- CREATE statement, B-1
- Creating
- transaction log table, 2-14
- Cursor loops
- restrictions, 3-7
D
- Data definition language, B-1
- Data dictionary
- views, C-2
- Data type
- BYTE, A-1
- BYTE VARYING, A-1
- C, A-1
- CHAR, A-1
- conversion, 3-4
- DATETIME, A-1
- DECIMAL, A-1
- FLOAT, A-1
- FLOAT4, A-1
- FLOAT8, A-1
- INTEGER, A-1
- INTEGER1, A-1
- INTEGER2, A-1
- INTEGER4, A-1
- LONG, A-2
- LONG BYTE, 3-7, A-2
- LONG RAW, A-2
- LONG VARCHAR, 3-7, A-2
- MONEY, A-2
- NUMBER, A-1
- OBJECT_KEY, A-2
- RAW, A-1
- SMALLINT, A-2
- TABLE_KEY, A-2
- TEXT, A-2
- VARBINARY, 3-10
- VARCHAR, A-2
- VARCHAR2, A-2
- Database link
- behavior, 2-8
- Date limits, 3-4
- DATETIME 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
- DROP statement, B-1
E
- Encrypted format login, 3-10
- Error messages
- error tracing, D-5
- Errors
- ORA-02070, 3-7
F
- FLOAT data type, A-1
- FLOAT4 data type, A-1
- FLOAT8 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
- HS_FDS_CONNECT_INFO initialization parameter, D-3
- HS_FDS_INGRES_MODE initialization parameter, D-4
- HS_FDS_RECOVERY_ACCOUNT initialization parameter, D-4
- HS_FDS_RECOVERY_PWD initialization parameter, D-4
- HS_FDS_TIMEZONE initialization parameter, D-5
- HS_FDS_TRACE_LEVEL initialization parameter, D-5
- HS_FDS_TRANSACTION_LOG initialization parameter, D-5
- HS_FDS_TRANSACTION_MODEL initialization parameter, D-6
- 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-1, B-2
- INTEGER data type, A-1
- INTEGER1 data type, A-1
- INTEGER2 data type, A-1
- INTEGER4 data type, A-1
K
- Known restrictions, 3-5
L
- listener.ora file, 2-10
- example, 2-4
- location, 2-3
- Locking, database, 3-5
- LONG BYTE data type, 3-7, A-2
- LONG data type, A-2
- LONG RAW data type, A-2
- LONG VARCHAR data type, 3-7, A-2
M
- MONEY data type, 3-11, A-2
N
- NUMBER data type, A-1
- NVL function, 4-6
O
- OBJECT_KEY data type, A-2
- Objects
- valid characters, 3-2
- Objects, naming rules, 3-2
- ORA-02070, 3-7
- Oracle Net Services
- configuring, 2-3
P
- Passing commands to database, 3-7
- Pass-Through Feature, 4-7
- Pattern matching, B-4
- PL/SQL, 3-12
R
- RAW data type, A-1
- RECOVERY_ACCOUNT
- account username, 2-13
- creating a recovery account, 2-13
- ROLLBACK
- restrictions, 3-7
- ROWID, 3-9
S
- savepoint support, 3-7
- SELECT statement, 4-7, B-2, C-1
- Set operations, B-4
- SID, 2-1
- SMALLINT data type, A-2
- Stored procedures, 3-9
- String functions, B-4
- SUM function, 4-6
T
- TABLE_KEY data type, A-2
- TEXT data type, A-2
- TNS listener
- configuring for gateway, 2-3
- starting, 2-5
- Transaction log table
- creating, 2-14
- transactional capability, 3-7
- transactional integrity, 3-6
- TRUNCATE statement, B-1
- Two-phase commit, 3-7
- configuration, 2-13
- transaction log table, 2-14
U
- UPDATE statement, 4-6, 4-7, B-2
- restrictions on use, 3-8
V
- VARBINARY data type, 3-10
- VARCHAR data type, A-2
- VARCHAR2 data type, A-2
W
- WHERE CURRENT OF clause, 3-8
