Index

A B C D E F G I L M 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, 13

BIT_COMPLEMENT function, 13

BIT_OR function, 13

BIT_XOR function, 13

BLOB_TABLE table type, 7

C

CANONICALIZE procedure, 8

CAPTURE_SNAPSHOT procedure and function, 10

CAST_FROM_BINARY_DOUBLE function, 13

CAST_FROM_BINARY_FLOAT function, 13

CAST_FROM_BINARY_INTEGER function, 13

CAST_FROM_NUMBER function, 13

CAST_TO_BINARY_DOUBLE function, 13

CAST_TO_BINARY_FLOAT function, 13

CAST_TO_BINARY_INTEGER function, 13

CAST_TO_NUMBER function, 13

CAST_TO_NVARCHAR2 function, 13

CAST_TO_RAW function, 13

CAST_TO_VARCHAR2 function, 13

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, 13

COMPARE Functions, 2

COMPILE_SCHEMA procedure, 8

CONCAT function, 13

CONVERT function, 13

CONVERTTOBLOB procedure, 2

CONVERTTOCLOB Procedure, 2

COPIES function, 13

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

DROP_SNAPSHOTS_RANGE procedures, 10

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, 12

UTL_FILE, 11

UTL_IDENT, 12

EXECUTE function, 7

EXECUTE_AND_FETCH function, 7

execution flow in dynamic SQL, 7

F

FCLOSE procedure, 11

FCLOSE_ALL procedure, 11

FCOPY procedure, 11

FETCH_ROWS function, 7

FFLUSH procedure, 11

FGETATTR procedure, 11

FGETPOS function, 11

FILE_TYPE record type, 11

FOPEN function, 11

FOPEN_NCHAR function, 11

FORMAT_CALL_STACK function, 8

FORMAT_ERROR_BACKTRACE function, 8

FORMAT_ERROR_STACK function, 8

FREETEMPORARY Procedures, 2

FREMOVE procedure, 11

FRENAME procedure, 11

FSEEK procedure, 11

G

GENERATE_REPORT_HTML procedure, 10

GENERATE_REPORT_TEXT procedure, 10

GET_CONFIG procedures, 10

GET_CPU_TIME function, 8

GET_DEPENDENCY procedure, 8

GET_ENDIANNESS function, 8

GET_HASH_VALUE function, 8

GET_LINE procedure, 4, 11

GET_LINE_NCHAR procedure, 11

GET_LINES procedure, 4

GET_POST_PROCESSED_SOURCE function, 5

GET_RAW function, 11

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, 11

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, 13

LOBs

DBMS_LOB package, 2

M

metrics--see TT_STATS

N

NAME_RESOLVE procedure, 8

NAME_TOKENIZE procedure, 8

NEW_LINE procedure, 4, 11

NORMAL function, 6

NUMBER_TABLE table type, 7

O

OPEN Procedures, 2

OPEN_CURSOR function, 7

OVERLAY function, 13

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, 11

PUT_LINE procedure, 4, 11

PUT_LINE_NCHAR procedure, 11

PUT_NCHAR procedure, 11

PUT_RAW procedure, 11

PUTF procedure, 11

PUTF_NCHAR procedure, 11

R

RANDOM function, 6

READ Procedures, 2

RECOMP_PARALLEL procedure, 14

RECOMP_SERIAL procedure, 14

referencing package contents, 1

REVERSE function, 13

S

SEED procedure, 6

SET_CONFIG procedure, 10

SHOW_SNAPSHOTS procedures, 10

SLEEP procedure, 3

SOURCE_LINES_T table type, 5

statistics--see TT_STATS

STRING function, 6

SUBSTR function, 13

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, 13

TRANSLITERATE function, 13

TRIM Procedures, 2

TT_DB_VERSION package

constants, 9

example, 12

using, 9

TT_STATS package

operational notes, 10

overview, 10

security model, required privilege, 10

subprograms summary, 10

using, 10

U

using TimesTen packages, 1

UTL_FILE package

data structures, 11

examples, 11

subprograms summary, 11

using, 11

UTL_IDENT package

constants, 12

example, 12

using, 12

UTL_RAW package

subprograms summary, 13

using, 13

UTL_RECOMP package

subprograms summary, 14

using, 14

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, 13