Skip Headers
Oracle® TimesTen In-Memory Database PL/SQL Packages Reference
Release 11.2.1
Part Number E14000-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Related Documents
Conventions
Documentation Accessibility
Technical support
1
Introduction to TimesTen-Supplied PL/SQL Packages and Types
Package overview
Package components
Using TimesTen-supplied packages
Referencing package contents
Running package examples
Summary of TimesTen-supplied PL/SQL packages
2
DBMS_LOCK
Using DBMS_LOCK
Summary of DBMS_LOCK subprograms
SLEEP procedure
3
DBMS_OUTPUT
Using DBMS_OUTPUT
Overview
Operational notes
Rules and limits
Exceptions
Example
Data structures
CHARARR table type
DBMSOUTPUT_LINESARRAY table type
Summary of DBMS_OUTPUT subprograms
DISABLE procedure
ENABLE procedure
GET_LINE procedure
GET_LINES procedure
NEW_LINE procedure
PUT procedure
PUT_LINE procedure
4
DBMS_PREPROCESSOR
Using DBMS_PREPROCESSOR
Overview
Operating notes
Data structures
SOURCE_LINES_T table type
Summary of DBMS_PREPROCESSOR subprograms
GET_POST_PROCESSED_SOURCE function
PRINT_POST_PROCESSED_SOURCE procedure
5
DBMS_RANDOM
Using DBMS_RANDOM
Operational notes
Summary of DBMS_RANDOM subprograms
INITIALIZE procedure
NORMAL function
RANDOM function
SEED procedure
STRING function
TERMINATE procedure
VALUE function
6
DBMS_SQL
Using DBMS_SQL
Overview
Security model
Constants
Operational notes
Execution flow
Processing queries
Processing updates, inserts, and deletes
Locating errors
Exceptions
Examples
Data structures
DESC_REC record type
DESC_REC2 record type
DESC_REC3 record type
BINARY_DOUBLE_TABLE table type
BINARY_FLOAT_TABLE table type
DATE_TABLE table type
DESC_TAB table type
DESC_TAB2 table type
DESC_TAB3 table type
INTERVAL_DAY_TO_SECOND_TABLE table type
INTERVAL_YEAR_TO_MONTH_TABLE table type
NUMBER_TABLE table type
TIME_TABLE table type
TIMESTAMP_TABLE table type
VARCHAR2_TABLE table type
VARCHAR2A table type
VARCHAR2S table type
Summary of DBMS_SQL subprograms
BIND_ARRAY procedure
BIND_VARIABLE procedure
CLOSE_CURSOR procedure
COLUMN_VALUE procedure
DEFINE_ARRAY procedure
DEFINE_COLUMN procedure
DESCRIBE_COLUMNS procedure
DESCRIBE_COLUMNS2 procedure
DESCRIBE_COLUMNS3 procedure
EXECUTE function
EXECUTE_AND_FETCH function
FETCH_ROWS function
IS_OPEN function
LAST_ERROR_POSITION function
LAST_ROW_COUNT function
LAST_ROW_ID function
LAST_SQL_FUNCTION_CODE function
OPEN_CURSOR function
PARSE procedure
TO_CURSOR_NUMBER function
TO_REFCURSOR function
VARIABLE_VALUE procedure
7
DBMS_UTILITY
Using DBMS_UTILITY
Security model
Constants
Types
dblink_array
index_table_type
instance_record
lname_array
name_array
number_array
uncl_array
Exceptions
Summary of DBMS_UTILITY subprograms
CANONICALIZE procedure
COMMA_TO_TABLE procedure
COMPILE_SCHEMA procedure
DB_VERSION procedure
FORMAT_CALL_STACK function
FORMAT_ERROR_BACKTRACE function
FORMAT_ERROR_STACK function
GET_CPU_TIME function
GET_DEPENDENCY procedure
GET_ENDIANNESS function
GET_HASH_VALUE function
GET_SQL_HASH function
GET_TIME function
INVALIDATE procedure
IS_BIT_SET function
NAME_RESOLVE procedure
NAME_TOKENIZE procedure
TABLE_TO_COMMA procedure
VALIDATE procedure
8
TT_DB_VERSION
Using TT_DB_VERSION
Overview
Constants
Examples
9
UTL_FILE
Using UTL_FILE
Security model
Operational notes
Rules and limits
Exceptions
Examples
Data structures
FILE_TYPE record type
Summary of UTL_FILE subprograms
FCLOSE procedure
FCLOSE_ALL procedure
FCOPY procedure
FFLUSH procedure
FGETATTR procedure
FGETPOS function
FOPEN function
FOPEN_NCHAR function
FREMOVE procedure
FRENAME procedure
FSEEK procedure
GET_LINE procedure
GET_LINE_NCHAR procedure
GET_RAW procedure
IS_OPEN function
NEW_LINE procedure
PUT procedure
PUT_LINE procedure
PUT_LINE_NCHAR procedure
PUT_NCHAR procedure
PUT_RAW procedure
PUTF procedure
PUTF_NCHAR procedure
10
UTL_IDENT
Using UTL_IDENT
Overview
Security model
Constants
Examples
11
UTL_RAW
Using UTL_RAW
Overview
Operational notes
Summary of UTL_RAW subprograms
BIT_AND function
BIT_COMPLEMENT function
BIT_OR function
BIT_XOR function
CAST_FROM_BINARY_DOUBLE function
CAST_FROM_BINARY_FLOAT function
CAST_FROM_BINARY_INTEGER function
CAST_FROM_NUMBER function
CAST_TO_BINARY_DOUBLE function
CAST_TO_BINARY_FLOAT function
CAST_TO_BINARY_INTEGER function
CAST_TO_NUMBER function
CAST_TO_NVARCHAR2 function
CAST_TO_RAW function
CAST_TO_VARCHAR2 function
COMPARE function
CONCAT function
CONVERT function
COPIES function
LENGTH function
OVERLAY function
REVERSE function
SUBSTR function
TRANSLATE function
TRANSLITERATE function
XRANGE function
12
UTL_RECOMP
Using UTL_RECOMP
Overview
Operational notes
Examples
Summary of UTL_RECOMP subprograms
RECOMP_PARALLEL procedure
RECOMP_SERIAL procedure
Index
Scripting on this page enhances content navigation, but does not change the content in any way.