Go to main content
14/14
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
BYTE data type,
A.1
C
Case rules,
3.2.2.3
Case studies,
4
case1.sql,
4.3
CHAR 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.7.2
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
CHAR,
A.1
conversion,
3.2.3.2
DATETIME,
A.1
,
A.1
DECIMAL,
A.1
DOUBLE PRECISION,
A.1
FLOAT,
A.1
INTEGER,
A.1
LONG,
A.1
LONG RAW,
A.1
MONEY,
A.1
NCHAR,
A.1
NUMERIC,
A.1
NVARCHAR,
A.1
REAL,
A.1
SERIAL,
A.1
SMALLFLOAT,
A.1
SMALLINT,
A.1
TEXT,
A.1
VARCHAR,
A.1
VARCHAR2,
A.1
Database link
behavior,
2.4
Date functions,
B.2.2.6
DATETIME data type,
A.1
,
A.1
DECIMAL data type,
A.1
DELETE statement,
4.9.1
,
B.1.1
,
B.2.1
restrictions on use,
3.3.7.5
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.6
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,
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_TRACE_LEVEL initialization parameter,
D.6
HS_FDS_TRANSACTION_LOG initialization parameter,
D.7
HS_FDS_TRANSACTION_MODEL initialization parameter,
D.8
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
restrictions on use,
3.3.7.4
,
3.3.7.5
INTEGER data type,
A.1
K
Known restrictions,
3.3
L
listener.ora file,
2.6.3
example,
2.2.1.2
location,
2.2.1
Locking, database,
3.2.5
LONG data type,
A.1
LONG RAW data type,
A.1
M
MONEY data type,
A.1
N
NCHAR data type,
3.3.6
,
A.1
NUMERIC data type,
A.1
NVARCHAR data type,
3.3.6
,
A.1
NVL function,
4.7
O
Objects
valid characters,
3.2.2.2
Objects, naming rules,
3.2.2.1
ORA-02070,
3.3.2
Oracle functions
TO_DATE,
B.2.3
Oracle Net Services
configuring,
2.2
P
Passing commands to database,
3.3.4
Pass-Through Feature,
4.11
Pattern matching,
B.2.2.5
PL/SQL,
3.4.3
,
3.4.4
R
RAW data type,
3.2.3.1
REAL data type,
3.3.5
,
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.7.1
,
3.3.7.6
S
savepoint support,
3.3.2
SELECT statement,
4.11.2
,
B.1.3
,
C.1.2
use of NULL keyword,
3.3.7.3
SERIAL data type,
A.1
Set operations,
B.2.2.5
SID,
2.1.1
SMALLFLOAT data type,
3.3.5
,
A.1
SMALLINT data type,
A.1
Stored procedures,
3.3.11
String functions,
B.2.2.4
SUM function,
4.7
T
TEXT data type,
A.1
TNS listener
configuring for gateway,
2.2.1
starting,
2.2.2
TO_DATE function,
B.2.3
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
restrictions on use,
3.3.7.5
V
VARCHAR data type,
A.1
VARCHAR2 data type,
A.1
W
WHERE CURRENT OF clause,
3.3.7.1
Scripting on this page enhances content navigation, but does not change the content in any way.