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.2.2.1
B
- BIGINT data type, A.1
- BINARY data type, A.1
- BIT data type, A.1
C
- Case rules, 3.4.3.2
- Case studies, 4
- Chained mode, 3.4.1
- CHAR data type, A.1
- COMMIT
-
- restrictions, 3.5.4
- Comparison operators, B.2.2.2
- CONCAT operator, 3.6.6
- Configuring
-
- two-phase commit, 2.7.1
- Configuring the gateway, 2.1
- CONNECT BY clause, 3.5.8.2
- COPY command, 3.5.10
- CREATE statement, B.1
- Creating
-
- transaction log table, 2.7.1.2
- Cursor loops
-
- restrictions, 3.5.4
D
- Data definition language, B.1
- Data dictionary
-
- views, C.1.4
- Data type
-
- BIGINT, A.1
- BINARY, A.1
- BIT, A.1
- CHAR, A.1
- conversion, 3.4.4.3
- DATE, A.1
- DATETIME, A.1
- DECIMAL, A.1
- FLOAT, A.1
-
- FLOAT data type, 3.6.1
- IMAGE, A.1
- INTEGER, A.1
- LONG, A.1
- LONG RAW, A.1
- MONEY, A.1
- NCHAR, A.1
- NTEXT, A.1
- NUMBER, A.1
- NUMERIC, A.1
- NVARCHAR, A.1
- RAW, A.1
- REAL, A.1
- SMALL DATETIME, A.1
- SMALL MONEY, A.1
- SMALLINT, A.1
- TEXT, A.1
- TIMESTAMP, A.1
- TINYINT, A.1
- UNIQUEIDENTIFIER, A.1
- VARBINARY, 3.6.2, 3.6.3, A.1
- VARCHAR, A.1
- Database link
-
- behavior, 2.4
- DATE data type, A.1
- DATETIME 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
- DROP statement, B.1
E
- Encrypted format login, 3.6.3
- Error messages
-
- error tracing, D.10
- Errors
-
- ORA-02070, 3.5.3
- Executing Stored Procedures, 4.12
F
- FLOAT data type, A.1
- Functions in SQL, 3.2
G
- Gateway
-
- case studies, 4
- data dictionary tables, C.1
- default SID, 2.1.1
- pass-through feature, 3.1, 3.5.7
- 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.4
H
- Hexadecimal notation, 3.4.4.1
- HS_FDS_CONNECT_INFO initialization parameter, D.2
- HS_FDS_DEFAULT_OWNER initialization parameter, 2.7.2, D.3
- HS_FDS_PARSER_TOKEN_SIZE initialization parameter, D.4
- HS_FDS_PROC_IS_FUNC initialization parameter, D.5
- HS_FDS_RECOVERY_ACCOUNT initialization parameter, D.6
- HS_FDS_RECOVERY_PWD initialization parameter, D.7, D.8
- HS_FDS_RESULTSET_SUPPORT initialization parameter, D.9
- HS_FDS_TRACE_LEVEL initialization parameter, D.10
- HS_FDS_TRANSACTION_LOG initialization parameter, D.11
- HS_FDS_TRANSACTION_MODEL initialization parameter, D.12
- HS_TRANSACTION_LOG, 2.7.1.2
I
- IMAGE data type, A.1
- 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
- INTEGER data type, A.1
K
- Known restrictions, 3.5
L
- listener.ora file, 2.6.2
-
- example, 2.2.1.2
- location, 2.2.1
- Locking, database, 3.4.6
- LONG data type, A.1
- LONG RAW data type, A.1
M
- MONEY data type, A.1
N
- NCHAR data type, A.1
- NTEXT data type, A.1
- NULL values, 3.4.2
- NUMBER data type, A.1
- NUMERIC data type, A.1
- NVARCHAR data type, A.1
- NVL function, 4.7
O
- Objects, naming rules, 3.4.3.1
- ORA-02070, 3.5.3
- Oracle Net Services
-
- configuring, 2.2
P
- Passing commands to database, 3.5.6
- Pass-Through Feature, 4.11
- Pattern Matching, B.2.2.3
- PL/SQL, 3.6.7, 3.6.8
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.5.4
- ROWID, 3.5.8.1, 3.5.8.6
S
- savepoint support, 3.5.3
- SELECT statement, 4.11.2, B.1.3, C.1.2
- SID, 2.1.1
- SMALL DATETIME data type, A.1
- SMALLINT data type, A.1
- Specifying an Owner, 2.7.2
- Stored procedures, 3.5.5, 3.6.9
-
- running in chained mode, 3.4.1
- Stored procedures in SQL Server, 3.2
- String functions, B.2.2.5, B.2.2.5
- SUM function, 4.7
T
- TEXT data type, A.1
- TIMESTAMP data type, A.1
- TINYINT data type, A.1
- TNS listener
-
- configuring for gateway, 2.2.1
- starting, 2.2.2
- Transaction log table
-
- creating, 2.7.1.2
- Transaction modes, 3.4.1
- transactional capability, 3.5.3
- transactional integrity, 3.5.2
- TRUNCATE statement, B.1
- Two-phase commit, 3.5.3
-
- configuration, 2.7.1
- transaction log table, 2.7.1.2
U
- UNIQUEIDENTIFIER data type, A.1
- UPDATE statement, 3.5.8.5, 4.9.2, 4.11.1, B.1.4, B.2.1
V
- VARBINARY data type, 3.6.2, 3.6.3, A.1
- VARCHAR data type, A.1
W
- WHERE CURRENT OF clause, 3.5.8.1