Skip Headers
Oracle® TimesTen In-Memory Database PL/SQL Packages Reference
11g Release 2 (11.2.2)

E21645-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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