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
- BINARY data type, A.1
- BIT data type, A.1
C
- Case rules, 3.3.3.2
- Case studies, 4
- Chained mode, 3.3.1
- CHAR data type, A.1
- COMMIT
-
- restrictions, 3.4.3
- Commit point site, 3.4.2
- Comparison operators, B.2.2.2
- CONCAT operator, 3.5.6
- Configuring
-
- two-phase commit, 2.7.1
- Configuring the gateway, 2.1
- CONNECT BY clause, 3.4.7.2
- COPY command, 3.4.8
- CREATE statement, B.1
- Creating
-
- transaction log table, 2.7.1.2
- Cursor loops
-
- restrictions, 3.4.3
D
- Data definition language, B.1
- Data dictionary
-
- views, C.1.4
- Data type
-
- BINARY, A.1
- BIT, A.1
- CHAR, A.1
- conversion, 3.3.4.2
- DATE, A.1
- DATETIME, A.1
- DECIMAL, A.1
- DOUBLE PRECISION, A.1
- FLOAT, A.1
-
- FLOAT data type, 3.5.1
- IMAGE, A.1
- INTEGER, A.1
- LONG, A.1
- LONG RAW, A.1
- MONEY, A.1
- NCHAR, 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
- TINYINT, A.1
- VARBINARY, 3.5.2, 3.5.3, A.1
- VARCHAR, A.1
- VARCHAR2, A.1
- Database link
-
- behavior, 2.4
- DATE data type, A.1
- DATETIME data type, A.1
- DDL statement, 3.4.5
- 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.5.3
- Error messages
-
- error tracing, D.9
- Errors
-
- ORA-02070, 3.4.2
- 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
- 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.3.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
- HS_FDS_RESULTSET_SUPPORT initialization parameter, D.8
- HS_FDS_TRACE_LEVEL initialization parameter, D.9
- HS_FDS_TRANSACTION_LOG initialization parameter, D.10
- HS_FDS_TRANSACTION_MODEL initialization parameter, D.11
- 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, 3.4.7.4, 4.9.3, B.1.2, B.2.1
- INTEGER data type, A.1
K
- Known restrictions, 3.4
L
- listener.ora file, 2.6.3
-
- example, 2.2.1.2
- location, 2.2.1
- Locking, database, 3.3.6
- LONG data type, A.1
- LONG RAW data type, A.1
M
- MONEY data type, A.1
N
- NCHAR data type, A.1
- NULL values, 3.3.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.3.3.1
- ORA-02070, 3.4.2
- Oracle Net Services
-
- configuring, 2.2
P
- Passing commands to database, 3.4.5
- Pass-Through Feature, 4.11
- Pass-through feature, 3.4.5
- PL/SQL, 3.5.7, 3.5.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.4.3
- ROWID, 3.4.7.1, 3.4.7.3
S
- savepoint support, 3.4.2
- 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.4.4, 3.5.9
-
- running in chained mode, 3.3.1
- Stored procedures in SQL Server, 3.2
- String functions, B.2.2.4, B.2.2.4
- SUM function, 4.7
T
- TEXT 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.3.1
- transactional capability, 3.4.2
- transactional integrity, 3.4.1
- TRUNCATE statement, B.1
- Two-phase commit, 3.4.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.5.2, 3.5.3, A.1
- VARCHAR data type, A.1
- VARCHAR2 data type, A.1
W
- WHERE CURRENT OF clause, 3.4.7.1