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