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
subprogram 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