Skip Headers
Oracle® TimesTen In-Memory Database PL/SQL Packages Reference
11
g
Release 2 (11.2.2)
E21645-06
Home
Book List
Contents
Master Index
Contact Us
Previous
View PDF
19/19
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
Scripting on this page enhances content navigation, but does not change the content in any way.