Index

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

A

anonymous PL/SQL blocks and dynamic SQL, 7

APPEND Procedures, 2

arrays

BIND_ARRAY procedure, 7

bulk DML using DBMS_SQL, 7

B

BINARY_DOUBLE_TABLE table type, 7

BINARY_FLOAT_TABLE table type, 7

bind parameter--see bind variable

bind variable, 7

BIND_ARRAY procedure, 7

BIND_VARIABLE procedure, 7

BIT_AND function, 12

BIT_COMPLEMENT function, 12

BIT_OR function, 12

BIT_XOR function, 12

BLOB_TABLE table type, 7

C

CANONICALIZE procedure, 8

CAST_FROM_BINARY_DOUBLE function, 12

CAST_FROM_BINARY_FLOAT function, 12

CAST_FROM_BINARY_INTEGER function, 12

CAST_FROM_NUMBER function, 12

CAST_TO_BINARY_DOUBLE function, 12

CAST_TO_BINARY_FLOAT function, 12

CAST_TO_BINARY_INTEGER function, 12

CAST_TO_NUMBER function, 12

CAST_TO_NVARCHAR2 function, 12

CAST_TO_RAW function, 12

CAST_TO_VARCHAR2 function, 12

CHARARR table type, 4

CLOB_TABLE table type, 7

CLOSE Procedure, 2

CLOSE_CURSOR procedure, 7

collections

scalar types for collections, 7

table items, 7

COLUMN_VALUE procedure, 7

COLUMN_VALUE_LONG procedure (not supported), 7

COMMA_TO_TABLE procedure, 8

COMPARE function, 12

COMPARE Functions, 2

COMPILE_SCHEMA procedure, 8

CONCAT function, 12

CONVERT function, 12

CONVERTTOBLOB procedure, 2

CONVERTTOCLOB Procedure, 2

COPIES function, 12

COPY Procedures, 2

CREATETEMPORARY Procedures, 2

cursors, DBMS_SQL package, 7

D

DATE_TABLE table type, 7

DB_VERSION procedure, 8

DBMS_LOB package, 2

DBMS_LOCK package

subprograms summary, 3

using, 3

DBMS_OUTPUT package

data structures, 4

example, 4

subprograms summary, 4

using, 4

DBMS_PREPROCESSOR package

data structures, 5

subprogram summary, 5

using, 5

DBMS_RANDOM package

supprogram summary, 6

using, 6

DBMS_SQL package

data structures, 7

examples, 7, 7, 7

subprograms summary, 7

using, 7

DBMS_UTILITY package

examples, 8, 8, 8

subprograms summary, 8

using, 8

DBMSOUTPUT_LINESARRAY table type, 4

DEFINE_ARRAY procedure, 7

DEFINE_COLUMN procedure, 7

DEFINE_COLUMN_LONG procedure (not supported), 7

DESC_REC record type, 7

DESC_REC2 record type, 7

DESC_REC3 record type, 7

DESC_TAB table type, 7

DESC_TAB2 table type, 7

DESC_TAB3 table type, 7

DESCRIBE_COLUMNS procedure, 7

DESCRIBE_COLUMNS2 procedure, 7

DESCRIBE_COLUMNS3 procedure, 7

DISABLE procedure, 4

dynamic SQL

anonymous blocks and, 7

DBMS_SQL functions, using, 7

execution flow in, 7

E

ENABLE procedure, 4

ERASE Procedures, 2

examples

DBMS_OUTPUT, 4

DBMS_SQL, 7

DBMS_SQL.TO_CURSOR_NUMBER, 7

DBMS_SQL.TO_REFCURSOR, 7

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE, 8

DBMS_UTILITY.INVALIDATE, 8

DBMS_UTILITY.VALIDATE, 8

TT_DB_VERSION, 11

UTL_FILE, 10

UTL_IDENT, 11

EXECUTE function, 7

EXECUTE_AND_FETCH function, 7

execution flow in dynamic SQL, 7

F

FCLOSE procedure, 10

FCLOSE_ALL procedure, 10

FCOPY procedure, 10

FETCH_ROWS function, 7

FFLUSH procedure, 10

FGETATTR procedure, 10

FGETPOS function, 10

FILE_TYPE record type, 10

FOPEN function, 10

FOPEN_NCHAR function, 10

FORMAT_CALL_STACK function, 8

FORMAT_ERROR_BACKTRACE function, 8

FORMAT_ERROR_STACK function, 8

FREETEMPORARY Procedures, 2

FREMOVE procedure, 10

FRENAME procedure, 10

FSEEK procedure, 10

G

GET_CPU_TIME function, 8

GET_DEPENDENCY procedure, 8

GET_ENDIANNESS function, 8

GET_HASH_VALUE function, 8

GET_LINE procedure, 4, 10

GET_LINE_NCHAR procedure, 10

GET_LINES procedure, 4

GET_POST_PROCESSED_SOURCE function, 5

GET_RAW function, 10

GET_SQL_HASH function, 8

GET_TIME function, 8

GETCHUNKSIZE Functions, 2

GETLENGTH Functions, 2

I

INITIALIZE procedure, 6

INSTR Functions, 2

INTERVAL_DAY_TO_SECOND_TABLE table type, 7

INTERVAL_YEAR_TO_MONTH_TABLE table type, 7

INVALIDATE procedure, 8

IS_BIT_SET function, 8

IS_OPEN function, 7, 10

ISOPEN Functions, 2

ISTEMPORARY Functions, 2

L

LAST_ERROR_POSITION function, 7

LAST_ROW_COUNT function, 7

LAST_ROW_ID function, 7

LAST_SQL_FUNCTION_CODE function, 7

LENGTH function, 12

LOBs

DBMS_LOB package, 2

N

NAME_RESOLVE procedure, 8

NAME_TOKENIZE procedure, 8

NEW_LINE procedure, 4, 10

NORMAL function, 6

NUMBER_TABLE table type, 7

O

OPEN Procedures, 2

OPEN_CURSOR function, 7

OVERLAY function, 12

overview of packages

package components, 1

referencing package contents, 1

summary of TimesTen packages, 1

using TimesTen packages, 1

P

PARSE procedure, 7

PRINT_POST_PROCESSED_SOURCE procedure, 5

PUT procedure, 4, 10

PUT_LINE procedure, 4, 10

PUT_LINE_NCHAR procedure, 10

PUT_NCHAR procedure, 10

PUT_RAW procedure, 10

PUTF procedure, 10

PUTF_NCHAR procedure, 10

R

RANDOM function, 6

READ Procedures, 2

RECOMP_PARALLEL procedure, 13

RECOMP_SERIAL procedure, 13

referencing package contents, 1

REVERSE function, 12

S

SEED procedure, 6

SLEEP procedure, 3

SOURCE_LINES_T table type, 5

STRING function, 6

SUBSTR function, 12

SUBSTR Functions, 2

summary of TimesTen packages, 1

T

TABLE_TO_COMMA procedure, 8

tables, table items as arrays, 7

TERMINATE procedure, 6

TIME_TABLE table type, 7

TIMESTAMP_TABLE table type, 7

TO_CURSOR_NUMBER function, 7

TO_REFCURSOR function, 7

TRANSLATE function, 12

TRANSLITERATE function, 12

TRIM Procedures, 2

TT_DB_VERSION package

constants, 9

example, 11

using, 9

U

using TimesTen packages, 1

UTL_FILE package

data structures, 10

examples, 10

subprograms summary, 10

using, 10

UTL_IDENT package

constants, 11

example, 11

using, 11

UTL_RAW package

subprograms summary, 12

using, 12

UTL_RECOMP package

subprograms summary, 13

using, 13

V

VALIDATE procedure, 8

VALUE function, 6

VARCHAR2_TABLE table type, 7

VARCHAR2A table type, 7

VARCHAR2S table type, 7

VARIABLE_VALUE procedure, 7

W

WRITE Procedures, 2

WRITEAPPEND Procedures, 2

X

XRANGE function, 12