Go to main content
1/19
Contents
Title and Copyright Information
Preface
Audience
Related Documents
Conventions
Documentation Accessibility
What's New
New features in Release 18.1.1.1.0
New features in Release 18.1.2.1.0
New features in Release 18.1.3.1.0
New features in Release 18.1.4.1.0
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_LOB
Using DBMS_LOB
Overview
Security model
Constants
Data types
Rules and limits
General rules and limits
Maximum LOB size
Maximum buffer size
Operational notes
Persistent LOBs
Temporary LOBs
Exceptions
Summary of DBMS_LOB subprograms
APPEND procedures
CLOSE procedures
COMPARE functions
CONVERTTOBLOB procedure
CONVERTTOCLOB procedure
COPY procedures
CREATETEMPORARY procedures
ERASE procedures
FREETEMPORARY procedures
GETCHUNKSIZE functions
GETLENGTH functions
GET_STORAGE_LIMIT functions
INSTR functions
ISOPEN functions
ISTEMPORARY functions
OPEN procedures
READ procedures
SUBSTR functions
TRIM procedures
WRITE procedures
WRITEAPPEND procedures
3
DBMS_LOCK
Using DBMS_LOCK
Summary of DBMS_LOCK subprograms
SLEEP procedure
4
DBMS_OUTPUT
Using DBMS_OUTPUT
Overview
Operational notes
Rules and limits
Exceptions
Examples
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
5
DBMS_PREPROCESSOR
Using DBMS_PREPROCESSOR
Overview
Operational notes
Data structures
SOURCE_LINES_T table type
Summary of DBMS_PREPROCESSOR subprograms
GET_POST_PROCESSED_SOURCE function
PRINT_POST_PROCESSED_SOURCE procedure
6
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
7
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
BLOB_TABLE table type
CLOB_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 procedures
TO_CURSOR_NUMBER function
TO_REFCURSOR function
VARIABLE_VALUE procedure
8
DBMS_UTILITY
Using DBMS_UTILITY
Security model
Constants
Data 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
9
TT_DB_VERSION
Using TT_DB_VERSION
Overview
Constants
Examples
10
TT_STATS
Using TT_STATS
Overview
Security model
Operational notes
Summary of TT_STATS subprograms
CAPTURE_SNAPSHOT procedure and function
DROP_SNAPSHOTS_RANGE procedures
GENERATE_REPORT_HTML procedure
GENERATE_REPORT_TEXT procedure
GET_CONFIG procedures
SET_CONFIG procedure
SHOW_SNAPSHOTS procedures
11
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
12
UTL_IDENT
Using UTL_IDENT
Overview
Security model
Constants
Examples
13
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
14
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.