Table of Contents
- Title and Copyright Information
- About This Content
- What's New
- 1 Introduction to TimesTen-Supplied PL/SQL Packages and Types
-
2
DBMS_LOB
- Using DBMS_LOB
-
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
- 4 DBMS_OUTPUT
- 5 DBMS_PREPROCESSOR
- 6 DBMS_RANDOM
-
7
DBMS_SQL
- Using DBMS_SQL
-
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
-
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
-
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
- 10 TT_STATS
-
11
UTL_FILE
- Using UTL_FILE
- Data Structures
-
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
-
13
UTL_RAW
- Using UTL_RAW
-
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