Index

A  B  C  D  E  F  G  I  L  N  O  P  R  S  T  U  V  X 

---

A

anonymous PL/SQL blocks and dynamic SQL, 6

arrays

BIND_ARRAY procedure, 6

bulk DML using DBMS_SQL, 6

---

B

BINARY_DOUBLE_TABLE table type, 6

BINARY_FLOAT_TABLE table type, 6

BIND_ARRAY procedure, 6

BIND_VARIABLE procedure, 6

BIT_AND function, 11

BIT_COMPLEMENT function, 11

BIT_OR function, 11

BIT_XOR function, 11

---

C

CANONICALIZE procedure, 7

CAST_FROM_BINARY_DOUBLE function, 11

CAST_FROM_BINARY_FLOAT function, 11

CAST_FROM_BINARY_INTEGER function, 11

CAST_FROM_NUMBER function, 11

CAST_TO_BINARY_DOUBLE function, 11

CAST_TO_BINARY_FLOAT function, 11

CAST_TO_BINARY_INTEGER function, 11

CAST_TO_NUMBER function, 11

CAST_TO_NVARCHAR2 function, 11

CAST_TO_RAW function, 11

CAST_TO_VARCHAR2 function, 11

CHARARR table type, 3

CLOSE_CURSOR procedure, 6

collections

scalar types for collections, 6

table items, 6

COLUMN_VALUE procedure, 6

COLUMN_VALUE_LONG procedure (not supported), 6

COMMA_TO_TABLE procedure, 7

COMPARE function, 11

COMPILE_SCHEMA procedure, 7

CONCAT function, 11

CONVERT function, 11

COPIES function, 11

cursors, DBMS_SQL package, 6

---

D

DATE_TABLE table type, 6

DB_VERSION procedure, 7

DBMS_LOCK package

subprograms summary, 2

using, 2

DBMS_OUTPUT package

data structures, 3

example, 3

subprograms summary, 3

using, 3

DBMS_PREPROCESSOR package

data structures, 4

subprogram summary, 4

using, 4

DBMS_RANDOM package

supprogram summary, 5

using, 5

DBMS_SQL package

data structures, 6

examples, 6, 6, 6

subprograms summary, 6

using, 6

DBMS_UTILITY package

examples, 7, 7, 7

subprograms summary, 7

using, 7

DBMSOUTPUT_LINESARRAY table type, 3

DEFINE_ARRAY procedure, 6

DEFINE_COLUMN procedure, 6

DEFINE_COLUMN_LONG procedure (not supported), 6

DESC_REC2 record type, 6

DESC_REC3 record type, 6

DESC_RESC record type, 6

DESC_TAB table type, 6

DESC_TAB2 table type, 6

DESC_TAB3 table type, 6

DESCRIBE_COLUMNS procedure, 6

DESCRIBE_COLUMNS2 procedure, 6

DESCRIBE_COLUMNS3 procedure, 6

DISABLE procedure, 3

dynamic SQL

anonymous blocks and, 6

DBMS_SQL functions, using, 6

execution flow in, 6

---

E

ENABLE procedure, 3

examples

DBMS_OUTPUT, 3

DBMS_SQL, 6

DBMS_SQL.TO_CURSOR_NUMBER, 6

DBMS_SQL.TO_REFCURSOR, 6

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE, 7

DBMS_UTILITY.INVALIDATE, 7

DBMS_UTILITY.VALIDATE, 7

TT_DB_VERSION, 10

UTL_FILE, 9

UTL_IDENT, 10

EXECUTE function, 6

EXECUTE_AND_FETCH function, 6

execution flow in dynamic SQL, 6

---

F

FCLOSE procedure, 9

FCLOSE_ALL procedure, 9

FCOPY procedure, 9

FETCH_ROWS function, 6

FFLUSH procedure, 9

FGETATTR procedure, 9

FGETPOS function, 9

FILE_TYPE record type, 9

FOPEN function, 9

FOPEN_NCHAR function, 9

FORMAT_CALL_STACK function, 7

FORMAT_ERROR_BACKTRACE function, 7

FORMAT_ERROR_STACK function, 7

FREMOVE procedure, 9

FRENAME procedure, 9

FSEEK procedure, 9

---

G

GET_CPU_TIME function, 7

GET_DEPENDENCY procedure, 7

GET_ENDIANNESS function, 7

GET_HASH_VALUE function, 7

GET_LINE procedure, 3, 9

GET_LINE_NCHAR procedure, 9

GET_LINES procedure, 3

GET_POST_PROCESSED_SOURCE function, 4

GET_RAW function, 9

GET_SQL_HASH function, 7

GET_TIME function, 7

---

I

INITIALIZE procedure, 5

INTERVAL_DAY_TO_SECOND_TABLE table type, 6

INTERVAL_YEAR_TO_MONTH_TABLE table type, 6

INVALIDATE procedure, 7

IS_BIT_SET function, 7

IS_OPEN function, 6, 9

---

L

LAST_ERROR_POSITION function, 6

LAST_ROW_COUNT function, 6

LAST_ROW_ID function, 6

LAST_SQL_FUNCTION_CODE function, 6

LENGTH function, 11

---

N

NAME_RESOLVE procedure, 7

NAME_TOKENIZE procedure, 7

NEW_LINE procedure, 3, 9

NORMAL function, 5

NUMBER_TABLE table type, 6

---

O

OPEN_CURSOR function, 6

OVERLAY function, 11

overview of packages

package components, 1

referencing package contents, 1

summary of TimesTen packages, 1

using TimesTen packages, 1

---

P

PARSE procedure, 6

PRINT_POST_PROCESSED_SOURCE procedure, 4

PUT procedure, 3, 9

PUT_LINE procedure, 3, 9

PUT_LINE_NCHAR procedure, 9

PUT_NCHAR procedure, 9

PUT_RAW procedure, 9

PUTF procedure, 9

PUTF_NCHAR procedure, 9

---

R

RANDOM function, 5

RECOMP_PARALLEL procedure, 12

RECOMP_SERIAL procedure, 12

referencing package contents, 1

REVERSE function, 11

---

S

SEED procedure, 5

SLEEP procedure, 2

SOURCE_LINES_T table type, 4

STRING function, 5

SUBSTR function, 11

summary of TimesTen packages, 1

---

T

TABLE_TO_COMMA procedure, 7

tables, table items as arrays, 6

TERMINATE procedure, 5

TIME_TABLE table type, 6

TIMESTAMP_TABLE table type, 6

TO_CURSOR_NUMBER function, 6

TO_REFCURSOR function, 6

TRANSLATE function, 11

TRANSLITERATE function, 11

TT_DB_VERSION package

constants, 8

example, 10

using, 8

---

U

using TimesTen packages, 1

UTL_FILE package

data structures, 9

examples, 9

subprograms summary, 9

using, 9

UTL_IDENT package

constants, 10

example, 10

using, 10

UTL_RAW package

subprograms summary, 11

using, 11

UTL_RECOMP package

subprograms summary, 12

using, 12

---

V

VALIDATE procedure, 7

VALUE function, 5

VARCHAR2_TABLE table type, 6

VARCHAR2A table type, 6

VARCHAR2S table type, 6

VARIABLE_VALUE procedure, 6

---

X

XRANGE function, 11