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

BYTE VARYING data type, A.1

C

C data type, A.1

Case rules, 3.2.1.3

Case studies, 4

CHAR data type, A.1

COLUMN_VALUE_LONG function, 3.3.5

COMMIT

restrictions, 3.3.3

Comparison operators, B.2.2.2

CONCAT operator, 3.4.4

Configuring the gateway, 2.1

CONNECT BY clause, 3.3.6.2

COPY command, 3.3.7

CREATE statement, B.1

Cursor loops

restrictions, 3.3.3

D

Data definition language, B.1

Data dictionary

views, C.1.4

Data type

BYTE, A.1

BYTE VARYING, A.1

C, A.1

CHAR, A.1

conversion, 3.2.2.3

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.1

LONG BYTE, 3.3.5, A.1

LONG RAW, A.1

LONG VARCHAR, 3.3.5, A.1

MONEY, A.1

NUMBER, A.1

OBJECT_KEY, A.1

RAW, A.1

SMALLINT, A.1

TABLE_KEY, A.1

TEXT, A.1

VARBINARY, 3.4.1

VARCHAR, A.1

VARCHAR2, A.1

Database link

behavior, 2.4

Date limits, 3.2.2.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.4.1

Error messages

error tracing, D.8

Errors

ORA-02070, 3.3.2

F

FLOAT data type, A.1

FLOAT4 data type, A.1

FLOAT8 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

Gateway Password Encryption Tool, 2.5

GRANT statement, B.1

Group functions, B.2.2.3

H

HS_FDS_CONNECT_INFO initialization parameter, D.2

HS_FDS_INGRES_MODE initialization parameter, D.3

HS_FDS_PARSER_TOKEN_SIZE initialization parameter, D.4

HS_FDS_RECOVERY_ACCOUNT initialization parameter, D.5

HS_FDS_RECOVERY_PWD initialization parameter, D.6

HS_FDS_TIMEZONE initialization parameter, D.7

HS_FDS_TRACE_LEVEL initialization parameter, D.8

HS_FDS_TRANSACTION_LOG initialization parameter, D.9

HS_FDS_TRANSACTION_MODEL initialization parameter, D.10

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

INTEGER data type, A.1

INTEGER1 data type, A.1

INTEGER2 data type, A.1

INTEGER4 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.4

LONG BYTE data type, 3.3.5, A.1

LONG data type, A.1

LONG RAW data type, A.1

LONG VARCHAR data type, 3.3.5, A.1

M

MONEY data type, 3.4.3, A.1

N

NUMBER data type, A.1

NVL function, 4.7

O

OBJECT_KEY data type, A.1

Objects

valid characters, 3.2.1.2

Objects, naming rules, 3.2.1.1

ORA-02070, 3.3.2

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.6

R

RAW data type, A.1

ROLLBACK

restrictions, 3.3.3

ROWID, 3.3.6.3

S

savepoint support, 3.3.2

SELECT statement, 4.11.2, B.1.3, C.1.2

Set operations, B.2.2.5

SID, 2.1.1

SMALLINT data type, A.1

Stored procedures, 3.3.9

String functions, B.2.2.4, B.2.2.4

SUM function, 4.7

T

TABLE_KEY data type, A.1

TEXT data type, A.1

TNS listener

configuring for gateway, 2.2.1

starting, 2.2.2

transactional capability, 3.3.2

transactional integrity, 3.3.1

TRUNCATE statement, B.1

Two-phase commit, 3.3.2

U

UPDATE statement, 4.9.2, 4.11.1, B.1.4, B.2.1

V

VARBINARY data type, 3.4.1

VARCHAR data type, A.1

VARCHAR2 data type, A.1

W

WHERE CURRENT OF clause, 3.3.6.1