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.2.2.1
B
- BYTE data type, A.1
- BYTEINT data type, A.1
C
- Case rules, 3.2.2.2
- Case studies, 4
- CHAR data type, A.1
- CHARACTER data type, A.1
- COMMIT
-
- restrictions, 3.3.3
- Commit point site, 3.3.2
- Comparison operators, B.2.2.2
- Configuring
-
- two-phase commit, 2.7.1
- Configuring the gateway, 2.1
- CONNECT BY clause, 3.3.6.2
- COPY command, 3.3.7
- CREATE statement, B.1
- Creating
-
- transaction log table, 2.7.1.2
- Cursor loops
-
- restrictions, 3.3.3
D
- Data definition language, B.1
- Data dictionary
-
- views, C.1.4
- Data type
-
- BYTE, A.1
- BYTEINT, A.1
- CHAR, A.1
- CHARACTER, A.1
- conversion, 3.2.3.3
- 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.1
- LONG VARCHAR, A.1
- NUMBER, A.1
- NUMERIC, A.1
- RAW, A.1
- REAL, A.1
- SMALLINT, A.1
- TIME, A.1
- TIMESTAMP, A.1
- VARBINARY, 3.4.1
- VARBYTE, A.1
- VARCHAR, A.1
- VARCHAR2, A.1
- Database link
-
- behavior, 2.4
- DATE data type, A.1
- DDL statement, 3.3.4
- DEC data type, A.1
- DECIMAL data type, A.1
- DELETE statement, 4.9.1, B.1.1, B.2.1
- Demo build SQL script, 4.3
- Demonstration files, 4.3
- Demonstration tables, 4.5
- Demonstration tables build SQL script, 4.5
- DOUBLE PRECISION data type, A.1
- DROP statement, B.1
E
- Encrypted format login, 3.4.1
- Error messages
-
- error tracing, D.7
- Errors
-
- ORA-02070, 3.3.2
F
- FLOAT data type, A.1
G
- Gateway
-
- case studies, 4
- data dictionary tables, C.1
- default SID, 2.1.1
- pass-through feature, 3.1
- supported functions, B
- supported SQL syntax, B.1
- system identifier (SID), 2.1.1
- two-phase commit, 2.7.1
- Gateway Password Encryption Tool, 2.5
- GRANT statement, B.1
- Group functions, B.2.2.3
H
- Hexadecimal notation, 3.2.3.1
- HS_FDS_CONNECT_INFO initialization parameter, D.2
- HS_FDS_PARSER_TOKEN_SIZE initialization parameter, D.3
- HS_FDS_RECOVERY_ACCOUNT initialization parameter, D.4
- HS_FDS_RECOVERY_PWD initialization parameter, D.5
- HS_FDS_SHAREABLE_NAME initialization parameter, D.6
- HS_FDS_TRACE_LEVEL initialization parameter, D.7
- HS_FDS_TRANSACTION_LOG initialization parameter, D.8
- HS_FDS_TRANSACTION_MODEL initialization parameter, D.9
- HS_TRANSACTION_LOG, 2.7.1.2
I
- Initialization parameter file
-
- customizing, 2.1.2, D
- initsid.ora file, 2.1.2, D
- INSERT statement, 4.9.3, B.1.2, B.2.1
- INT data type, A.1
- INTEGER data type, A.1
- INTERVAL data type, A.1
K
- Known restrictions, 3.3
L
- listener.ora file, 2.6.2
-
- example, 2.2.1.2
- location, 2.2.1
- Locking, database, 3.2.5
- LONG data type, A.1
- LONG VARCHAR data type, A.1
N
- NUMBER data type, A.1
- NUMERIC data type, A.1
- NVL function, 4.7
O
- Objects, naming rules, 3.2.2.1
- ODBC connectivity
-
- specifying path to library, D.6
- ORA-02070, 3.3.2
- Oracle Net Services
-
- configuring, 2.2
P
- Passing commands to database, 3.3.4
- Pass-Through Feature, 4.11
- PL/SQL, 3.4.3, 3.4.4
R
- RAW data type, A.1
- REAL data type, A.1
- RECOVERY_ACCOUNT
-
- account username, 2.7.1.1
- creating a recovery account, 2.7.1.1
- ROLLBACK
-
- restrictions, 3.3.3
- ROWID, 3.3.6.1, 3.3.6.3
S
- savepoint support, 3.3.2
- SELECT statement, 4.11.2, B.1.3, C.1.2
- SID, 2.1.1
- SMALLINT data type, A.1
- Stored procedures, 3.3.9
- String functions, B.2.2.4
- SUM function, 4.7
T
- TIME data type, A.1
- TIMESTAMP data type, A.1
- TNS listener
-
- configuring for gateway, 2.2.1
- starting, 2.2.2
- Transaction log table
-
- creating, 2.7.1.2
- transactional capability, 3.3.2
- transactional integrity, 3.3.1
- TRUNCATE statement, B.1
- Two-phase commit, 3.3.2
-
- configuration, 2.7.1
- transaction log table, 2.7.1.2
U
- UPDATE statement, 4.9.2, 4.11.1, B.1.4, B.2.1
V
- VARBINARY data type, 3.4.1
- VARBYTE data type, A.1
- VARCHAR data type, A.1
- VARCHAR2 data type, A.1
W
- WHERE CURRENT OF clause, 3.3.6.1