Oracle STANDARD
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Essentially every Oracle built-in function, package, procedure, and type is dependent on the STANDARD package. You can not do much more than stare at the command-line without interacting with this package. This page, and the header source code, are a great way to begin digging into the internals.

It is important when looking at the contents of STANDARD to understand that Oracle has intentionally exposed most of the contents for general use but protected others: Here is an example of the later.

SQL> DECLARE
  2   TYPE time IS NEW DATE_BASE;
  3  BEGIN
  4    NULL;
  5  END;
  6  /
TYPE TIME is new DATE_BASE;
*
ERROR at line 2:
ORA-06550: line 2, column 15:
PLS-00504: type DATE_BASE may not be used outside of package STANDARD
ORA-06550: line 2, column 2:
PL/SQL: Item ignored
AUTHID CURRENT_USER
Constants
Name Data Type Value
BINARY DOUBLE
BINARY_DOUBLE_INFINITY BINARY_DOUBLE BINARY_DOUBLE_INFINITY
BINARY_DOUBLE_MAX_NORMAL BINARY_DOUBLE BINARY_DOUBLE_MAX_NORMAL
BINARY_DOUBLE_MAX_SUBNORMAL BINARY_DOUBLE BINARY_DOUBLE_MAX_SUBNORMAL
BINARY_DOUBLE_MIN_NORMAL BINARY_DOUBLE BINARY_DOUBLE_MIN_NORMAL
BINARY_DOUBLE_MIN_SUBNORMAL BINARY_DOUBLE BINARY_DOUBLE_MIN_SUBNORMAL
BINARY_DOUBLE_NAN BINARY_DOUBLE BINARY_DOUBLE_NAN
BINARY FLOAT
BINARY_FLOAT_INFINITY BINARY_FLOAT BINARY_FLOAT_INFINITY
BINARY_FLOAT_MAX_NORMAL BINARY_FLOAT BINARY_FLOAT_MAX_NORMAL
BINARY_FLOAT_MAX_SUBNORMAL BINARY_FLOAT BINARY_FLOAT_MAX_SUBNORMAL
BINARY_FLOAT_MIN_NORMAL BINARY_FLOAT BINARY_FLOAT_MIN_NORMAL
BINARY_FLOAT_MIN_SUBNORMAL BINARY_FLOAT BINARY_FLOAT_MIN_SUBNORMAL
BINARY_FLOAT_NAN BINARY_FLOAT BINARY_FLOAT_NAN
DECLARE
 x BINARY_DOUBLE := BINARY_DOUBLE_INFINITY;
BEGIN
  NULL;
END;
/
Data Types: Boolean type BOOLEAN is (FALSE, TRUE);
Data Types Date and Time type DATE is DATE_BASE;
type TIME is new DATE_BASE;
type TIMESTAMP is new DATE_BASE;
type "TIME WITH TIME ZONE" is new DATE_BASE;
type "TIMESTAMP WITH TIME ZONE" is new DATE_BASE;
type "INTERVAL YEAR TO MONTH" is new DATE_BASE;
type "INTERVAL DAY TO SECOND" is new DATE_BASE;

 subtype TIME_UNCONSTRAINED is TIME(9);
 subtype TIME_TZ_UNCONSTRAINED is TIME(9) WITH TIME ZONE;
 subtype TIMESTAMP_UNCONSTRAINED is TIMESTAMP(9);
 subtype TIMESTAMP_TZ_UNCONSTRAINED is TIMESTAMP(9) WITH TIME ZONE;
 subtype YMINTERVAL_UNCONSTRAINED is INTERVAL YEAR(9) TO MONTH;
 subtype DSINTERVAL_UNCONSTRAINED is INTERVAL DAY(9) TO SECOND (9);

type "TIMESTAMP WITH LOCAL TIME ZONE" is new DATE_BASE;
 subtype TIMESTAMP_LTZ_UNCONSTRAINED is TIMESTAMP(9) WITH LOCAL TIME ZONE;
Data Types: Large Objects type BFILE is BFILE_BASE;
type BLOB is BLOB_BASE;
 subtype "BINARY LARGE OBJECT" is BLOB;
type CLOB is CLOB_BASE;
 subtype "CHARACTER LARGE OBJECT" is CLOB;
 subtype "CHAR LARGE OBJECT" is CLOB;
 subtype "NATIONAL CHARACTER LARGE OBJEC" is CLOB CHARACTER SET NCHAR_CS;
 subtype "NCHAR LARGE OBJECT" is CLOB CHARACTER SET NCHAR_CS;
 subtype "NCLOB" is CLOB CHARACTER SET NCHAR_CS;
Data Types: Numeric type NUMBER is NUMBER_BASE;
 subtype FLOAT is NUMBER; -- NUMBER(126)
 subtype REAL is FLOAT; -- FLOAT(63)
 subtype "DOUBLE PRECISION" is FLOAT;
 subtype INTEGER is NUMBER(38,0);
 subtype INT is INTEGER;
 subtype SMALLINT is NUMBER(38,0);
 subtype DECIMAL is NUMBER(38,0);
 subtype NUMERIC is DECIMAL;
 subtype DEC is DECIMAL;

 subtype BINARY_INTEGER is INTEGER range '-2147483647'..2147483647;
 subtype NATURAL is BINARY_INTEGER range 0..2147483647;
 subtype NATURALN is NATURAL not null;
 subtype POSITIVE is BINARY_INTEGER range 1..2147483647;
 subtype POSITIVEN is POSITIVE not null;
 subtype SIGNTYPE is BINARY_INTEGER range '-1'..1;
 subtype PLS_INTEGER is BINARY_INTEGER;

 subtype BINARY_FLOAT is NUMBER;
 subtype BINARY_DOUBLE is NUMBER;

 -- simple scalar types
 subtype SIMPLE_INTEGER is BINARY_INTEGER NOT NULL;
 subtype SIMPLE_FLOAT is BINARY_FLOAT NOT NULL;
 subtype SIMPLE_DOUBLE is BINARY_DOUBLE NOT NULL;
Data Types String: Fixed Length (ANSI)  subtype CHAR is VARCHAR2;
 subtype CHARACTER is CHAR;

 subtype "NATIONAL CHARACTER" is CHAR CHARACTER SET NCHAR_CS;
 subtype "NATIONAL CHAR" is CHAR CHARACTER SET NCHAR_CS;
 subtype "NCHAR" is CHAR CHARACTER SET NCHAR_CS;
 subtype "NATIONAL CHARACTER VARYING" is VARCHAR CHARACTER SET NCHAR_CS;
 subtype "NATIONAL CHAR VARYING" is VARCHAR CHARACTER SET NCHAR_CS;
 subtype "NCHAR VARYING" is VARCHAR CHARACTER SET NCHAR_CS;
 subtype "NVARCHAR2" is VARCHAR2 CHARACTER SET NCHAR_CS;
Data Types String: Variable Length type VARCHAR2 is NEW CHAR_BASE;
 subtype LONG is VARCHAR2(32760);
 subtype "LONG RAW" is RAW(32760);
 subtype RAW is VARCHAR2;
 subtype STRING is VARCHAR2;
 subtype VARCHAR is VARCHAR2;
 subtype "CHARACTER VARYING" is VARCHAR;
 subtype "CHAR VARYING" is VARCHAR;
Data Types: Miscellaneous type MLSLABEL is new CHAR_BASE;
 subtype ROWID is VARCHAR2(256);
type UROWID IS NEW CHAR_BASE;

type "<ADT_1>" as object (dummy char(1));
type "<RECORD_1>" is record (dummy char(1));
type "<TUPLE_1>" as object (dummy char(1));
type "<VARRAY_1>" is varray(1) of char(1);
type "<V2_TABLE_1>" is table of char(1) index by binary_integer;
type "<TABLE_1>" is table of char(1);
type "<COLLECTION_1>" is table of char(1);
type "<REF_CURSOR_1>" is ref cursor;

-- this will actually match against a Q_TABLE
type "<TYPED_TABLE>" is table of "<ADT_1>";
 subtype "<ADT_WITH_OID>" is "<TYPED_TABLE>";

/* The following generic index table data types are used by the PL/SQL compiler to materialize an array attribute at runtime */
type " SYS$INT_V2TABLE" is table of pls_integer index by binary_integer;

/* The following record type and the corresponding generic index table data types are used by the PL/SQL compiler to materialize a table at runtime in order to record the exceptions raised during the execution of FORALL bulk bind statement. */
type " SYS$BULK_ERROR_RECORD" is
record (error_index pls_integer, error_code pls_integer);

type " SYS$REC_V2TABLE" is table of " SYS$BULK_ERROR_RECORD"
index by binary_integer;

-- Adding a generic weak ref cursor type
type sys_refcursor is ref cursor;

-- the following data type is a generic for all opaque types
type "<OPAQUE_1>" as opaque FIXED(1) USING LIBRARY dummy_lib
(static function dummy return number);

type "<ASSOC_ARRAY_1>" is table of char(1) index by varchar2(1);
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'STANDARD'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'STANDARD';

-- this query returns 5,439 rows
Documented No
Exceptions
Error Code Reason
ORA-00001 DUP_VAL_ON_INDEX
ORA-00012 NOT_LOGGED_ON
ORA-00017 LOGIN_DENIED
ORA-00051 TIMEOUT_ON_RESOURCE
ORA-00100 NO_DATA_FOUND
ORA-01001 INVALID_CURSOR
ORA-01012 NOT_LOGGED_ON
ORA-01017 LOGIN_DENIED
ORA-01410 SYS_INVALID_ROWID
ORA-01422 TOO_MANY_ROWS
ORA-01476 ZERO_DIVIDE
ORA-01722 INVALID_NUMBER
ORA-01725 USERENV_COMMITSCN_ERROR
ORA-06500 STORAGE_ERROR
ORA-06501 PROGRAM_ERROR
ORA-06502 VALUE_ERROR
ORA-06504 ROWTYPE_MISMATCH
ORA_06511 CURSOR_ALREADY_OPEN
ORA-06530 ACCESS_INTO_NULL
ORA-06531 COLLECTION_IS_NULL
ORA-06532 SUBSCRIPT_OUTSIDE_LIMIT
ORA-06533 SUBSCRIPT_BEYOND_COUNT
ORA-06548 NO_DATA_NEEDED
ORA-06592 CASE_NOT_FOUND
ORA-30625 SELF_IS_NULL
First Available 7.3.4
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/stdspec.sql
 
Functions
Object Name Overloads Relevant Libary Page
(+)   -- outer join
Joins
function '(+)' ( colname "<OPAQUE_1>") return "<OPAQUE_1>";
ABS 4 Numeric Function
ACOS 2 Numeric Function
ADD_MONTHS 2 Date Function
ASCII   String Function
ASCIISTR   Conversion Function
ASIN 2 Numeric Function
ATAN 2 Numeric Function
ATAN2 2 Numeric Function
BFILENAME   Conversion Function
BITAND 2 Numeric Function
CARDINALITY   Collection Function
CEIL 3 Numeric Function
CHARTOROWID 1 Conversion Function
CHR   String Function
COALESCE   String Function
COMPOSE   Conversion Function
CONCAT 2 String Function
CONVERT 4 Conversion Function and String Function
COS 2 Numeric Function
COSH 2 Numeric Function
CUBE   Rollup and Cube
CURRENT_DATE   Date Function
CURRENT_TIME   standard.current_time RETURN TIME_TZ_UNCONSTRAINED;
Not-functional as SELECT current_time FROM dual;
CURRENT_TIMESTAMP   Timestamp Function
DBTIMEZONE   Timestamp Function
DECODE 11 DECODE and CASE
DECOMPOSE   Conversion Function
DEREF   Nested Table Constraints
DUMP 3 Date Function, Numeric Function, and String Function
EMPTY_BLOB   standard.empty_blob RETURN BLOB;
DBMS_LOB
EMPTY_CLOB   standard.empty_clob RETURN CLOB;
DBMS_LOB
EXISTS   Conditions
EXP 2 Numeric Function
FLOOR 3 Numeric Function
FROM_TZ   Timestamp Function
GLB   -- group function
standard.glb(label IN MLSLABEL) RETURN MLSLABEL;
TBD
GREATEST 13 Date Function, Numeric Function, and String Function
GREATEST_LB   -- vararg routines - icds in stdbdy
standard.greatest_lb(pattern IN MLSLABEL) RETURN MLSLABEL;
TBD
GROUPING 3 Rollup and Cube
HEXTORAW   Conversion Function
INITCAP   String Function
INSTR 2 String Function
INSTR2   String Function
INSTR4   String Function
INSTRB 2 String Function
INSTRC   String Function
ISNCHAR   -- implemented as a icd call, returns TRUE if NCHAR, otherwise FALSE
standard.isnchar(c IN VARCHAR2) RETURN BOOLEAN
set serveroutput on

DECLARE
 rc CHAR(4);
 nc NCHAR(4);
BEGIN
  IF standard.isnchar(rc) THEN
    dbms_output.put_line('RC');
  END IF;
  IF standard.isnchar(nc) THEN
    dbms_output.put_line('NC');
  END IF;
END;
/
LAST_DAY   Date Function
LEAST 13 Date Function, Numeric Function, and String Function
LEAST_UB   -- vararg routines - icds in stdbdy
standard.least_ub(pattern IN MLSLABEL) RETURN MLSLABEL;
TBD
LENGTH 3 Numeric Function and String Function
LENGTH2   Numeric Function
LENGTH4   Numeric Function
LENGTHB 3 Numeric Function
LENGTHC   Numeric Function
LEVEL   standard.level RETURN NUMBER;
Connect By
LIKE 4 Conditions
LIKEC 2 Conditions
LIKE2 2 Conditions
LIKE4 2 Conditions
LN 2 Numeric Function
LOCALTIME   Timestamp Function
LOCALTIMESTAMP   Timestamp Function
LOG 2 Numeric Function
LOWER 2 String Function
LPAD 4 String Function
LTRIM 4 String Function
LUB   -- group function
standard.lub(label IN MLSLABEL) RETURN MLSLABEL
TBD
MOD 3 Numeric Function
MONTHS_BETWEEN   Date Function
MULTISET_EXCEPT_ALL   Operators
MULTISET_EXCEPT_DISTINCT   Operators
MULTISET_INTERSECT_ALL   Operators
MULTISET_INTERSECT_DISTINCT   Operators
MULTISET_UNION_ALL   Operators
MULTISET_UNION_DISTINCT   Operators
NANVL 3 Numeric Function
NCHARTOROWID   standard.nchartorowid(str IN NVARCHAR2) RETURN ROWID;
conn / as sysdba

SELECT rowid
FROM hr.employees;

SELECT last_name
FROM hr.employees
WHERE ROWID = standard.nchartorowid('AAARAgAAFAAAABYABQ');
NCHR   standard.nchr(n IN PLS_INTEGER) RETURN NVARCHAR2;
SELECT(nchr(68) || nchr(65) || nchr(78))
FROM dual;
NEW_TIME   Date Function
NEXT_DAY   Date Function
NHEXTORAW   standard.nhextoraw(c IN NVARCHAR2) RETURN RAW;
set serveroutput on

DECLARE
  nv NVARCHAR2(10) := 'F30201';
  rw RAW(32);
BEGIN
  rw := standard.nhextoraw(nv);
  dbms_output.put_line(rw);
END;
/
NLSSORT 2 String Function
NLS_CHARSET_DECL_LEN   Character Set Functions
NLS_CHARSET_ID   Character Set Functions
NLS_CHARSET_NAME   Character Set Functions
NLS_INITCAP 2 String Function
NLS_LOWER 4 String Function
NLS_UPPER 4 String Function
NOT_LIKE 4 Conditions
NOT_LIKEC 2 Conditions
NOT_LIKE2 2 Conditions
NOT_LIKE4 2 Conditions
NULLFN   standard.nullfn(str IN VARCHAR2) RETURN RAW;
SELECT standard.nullfn('A') FROM dual;
NULLIF 4 Miscellaneous Function
NUMTODSINTERVAL   Conversion Function
NUMTOYMINTERVAL   Conversion Function
NVL 21 Miscellaneous Function
POWER 2 Numeric Function
PRIOR 3 Connect By
RAWTOHEX   Conversion Function
RAWTONHEX   Conversion Function
REF   Nested Table Constraints
REGEXP_COUNT 2 Regular Expression
REGEXP_INSTR 2 Regular Expression
REGEXP_LIKE 2 Regular Expression
REGEXP_REPLACE 2 Regular Expression
REGEXP_SUBSTR 2 Regular Expression
REMAINDER 3 Numeric Function
'REM'

I can make it work but I can't answer the question "why does it exist?"
3 function 'REM' (LEFT NUMBER, RIGHT NUMBER) return NUMBER;

SELECT -2rem2 FROM dual;

      REM2
----------
        -2
REPLACE 2 Translate - Replace
ROLLUP   Rollup and Cube
ROUND 6 Numeric Function
ROWID   Here's what the source code states:

-- ROWID: this dreadful identifier is supposed to represent a
-- datatype outside of SQL and and a pseudo-column (function, to
-- us) when inside a sql statement. ADA data model doesn't allow
-- for any function X return X;
-- so we must special case this. Yuk. There's special-case code
-- in ph2nre which maps "rowid" to "rowid " if we're inside a SQL
-- stmt.
function "ROWID " RETURN ROWID;
pragma builtin('ROWID ', 1, 209, 240); -- this had better never be called.

I suspect this warning should be taken seriously though it does beg the question of why it was exposed. The comments, of course, are the reward for reading these files.
ROWIDTOCHAR   Conversion Function
ROWIDTONCHAR   Conversion Function
ROWLABEL   standard.rowlabel RETURN MLSLABEL; -- defines a pseudocolumn
TBD
ROWNUM   standard.rownum RETURN NUMBER;
Pseudocolumns
RPAD 4 String Function
RTRIM 4 String Function
SESSIONTIMEZONE   Timestamp Functions
SET   standard.set(collection IN "<TABLE_1>") RETURN "<TABLE_1>";
TBD
SIGN 4 Numeric Function
SIN 2 Numeric Function
SINH 2 Numeric Function
SOUNDEX   String Function
SQLCODE   Exception Handling
SQLERRM 2 Exception Handling
SQRT 3 Numeric Function
SUBMULTISET   Conditions
SUBSTR 2 String Function
SUBSTR2   String Function
SUBSTR4   String Function
SUBSTRB 2 String Function
SUBSTRC   String Function
" SYS$DSINTERVALSUBTRACT" 5 function " SYS$DSINTERVALSUBTRACT"(
LEFT  TIMESTAMP_UNCONSTRAINED,
RIGHT TIMESTAMP_UNCONSTRAINED)
return DSINTERVAL_UNCONSTRAINED ;

function " SYS$DSINTERVALSUBTRACT"
(LEFT TIMESTAMP_TZ_UNCONSTRAINED, RIGHT TIMESTAMP_TZ_UNCONSTRAINED)
return DSINTERVAL_UNCONSTRAINED ;

function " SYS$DSINTERVALSUBTRACT" (LEFT TIME_UNCONSTRAINED,
RIGHT TIME_UNCONSTRAINED)
return DSINTERVAL_UNCONSTRAINED ;

function " SYS$DSINTERVALSUBTRACT"
(LEFT TIME_TZ_UNCONSTRAINED, RIGHT TIME_TZ_UNCONSTRAINED)
return DSINTERVAL_UNCONSTRAINED ;

function " SYS$DSINTERVALSUBTRACT"(LEFT TIMESTAMP_LTZ_UNCONSTRAINED,
RIGHT TIMESTAMP_LTZ_UNCONSTRAINED)
return dsinterval_unconstrained;
" SYS$EXTRACT_FROM" 8 function " SYS$EXTRACT_FROM"
(T TIME_UNCONSTRAINED,FIELD VARCHAR2) return NUMBER;

function " SYS$EXTRACT_FROM"
(T TIME_TZ_UNCONSTRAINED,FIELD varchar2) return NUMBER;

function " SYS$EXTRACT_FROM"
(T TIMESTAMP_UNCONSTRAINED,FIELD VARCHAR2) return NUMBER;

function " SYS$EXTRACT_FROM"
(T TIMESTAMP_TZ_UNCONSTRAINED,FIELD VARCHAR2) return NUMBER;

function " SYS$EXTRACT_FROM"
(T TIMESTAMP_LTZ_UNCONSTRAINED,FIELD varchar2) return NUMBER;

function " SYS$EXTRACT_FROM"
(T DATE,FIELD VARCHAR2) return NUMBER;

function " SYS$EXTRACT_FROM"
(I YMINTERVAL_UNCONSTRAINED,FIELD VARCHAR2) return NUMBER;

function " SYS$EXTRACT_FROM"
(I DSINTERVAL_UNCONSTRAINED,FIELD VARCHAR2) return NUMBER;
" SYS$EXTRACT_STRING_FROM" 3 function " SYS$EXTRACT_STRING_FROM"
(T TIME_TZ_UNCONSTRAINED,FIELD varchar2) return VARCHAR2;

function " SYS$EXTRACT_STRING_FROM"
(T TIMESTAMP_TZ_UNCONSTRAINED,FIELD VARCHAR2) return VARCHAR2;

function " SYS$EXTRACT_STRING_FROM"
(T TIMESTAMP_LTZ_UNCONSTRAINED,FIELD varchar2) return VARCHAR2;
SYS$LOB_REPLICATION 2 standard.sys$lob_replication(x IN BLOB) RETURN BLOB;

standard.sys$lob_replication(x IN CLOB CHARACTER SET ANY_CS)
RETURN CLOB CHARACTER SET x%CHARSET;
TBD
" SYS$STANDARD_CHR"
(and the space in the name is correct)
  standard." SYS$STANDARD_CHR"(n INTEGER, csn VARCHAR2 CHARACTER SET ANY_CS)
RETURN VARCHAR2 CHARACTER SET csn%CHARSET;
DECLARE
 x VARCHAR2(10);
BEGIN
  x := standard." SYS$STANDARD_CHR"(65, 'WE8MSWIN1252');
END;
/
       *
ERROR at line 4:
ORA-06550: line 4, column 8:
PLS-01917: illegal reference to package STANDARD item 'STANDARD. SYS$STANDARD_CHR(65, WE8MSWIN1252)'
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
" SYS$STANDARD_TRANSLATE"
(and the space in the name is correct)
  standard." SYS$STANDARD_TRANSLATE" (
src VARCHAR2 CHARACTER SET ANY_CS,
csn VARCHAR2 CHARACTER SET ANY_CS)
RETURN VARCHAR2 CHARACTER SET csn%CHARSET;
DECLARE
 x VARCHAR2(10);
BEGIN
  x := standard." SYS$STANDARD_TRANSLATE"('ABCDEFG', 'abcdefg');
END;
/
x := standard." SYS$STANDARD_TRANSLATE"('ABCDEFG', 'abcdefg');
     *
ERROR at line 4:
ORA-06550: line 4, column 8:
PLS-01917: illegal reference to package STANDARD item 'STANDARD. SYS$STANDARD_TRANSLATE(ABCDEFG, abcdefg)'
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
" SYS$STANDARD_TRIM"
(and the space in the name is correct)
6 function " SYS$STANDARD_TRIM" (v VARCHAR2 CHARACTER SET ANY_CS)
return VARCHAR2 CHARACTER SET v%CHARSET;

function " SYS$STANDARD_TRIM" (STR1 VARCHAR2 CHARACTER SET ANY_CS ,
TRFLAG PLS_INTEGER)
return VARCHAR2 CHARACTER SET STR1%CHARSET;

function " SYS$STANDARD_TRIM" (STR1 VARCHAR2 CHARACTER SET ANY_CS ,
TSET VARCHAR2 CHARACTER SET STR1%CHARSET,
TRFLAG PLS_INTEGER)
return VARCHAR2 CHARACTER SET STR1%CHARSET;

function " SYS$STANDARD_TRIM" (v CLOB CHARACTER SET ANY_CS)
return CLOB CHARACTER SET v%CHARSET;

function " SYS$STANDARD_TRIM" (STR1 CLOB CHARACTER SET ANY_CS ,
TRFLAG PLS_INTEGER)
return CLOB CHARACTER SET STR1%CHARSET;

function " SYS$STANDARD_TRIM" (STR1 CLOB CHARACTER SET ANY_CS ,
TSET CLOB CHARACTER SET STR1%CHARSET,
TRFLAG PLS_INTEGER)
return CLOB CHARACTER SET STR1%CHARSET;
" SYS$YMINTERVALSUBTRACT"   function " SYS$YMINTERVALSUBTRACT"(
LEFT  TIMESTAMP_UNCONSTRAINED,
RIGHT TIMESTAMP_UNCONSTRAINED)
return YMINTERVAL_UNCONSTRAINED ;
SYSDATE   Date Function
SYSTIMESTAMP   Timestamp Function
SYS_AT_TIME_ZONE 2 Timestamp Function
SYS_CONTEXT 2 Environment Function
SYS_EXTRACT_UTC   Timestamp Function
SYS_GUID   Miscellaneous Functions
SYS_LITERALTODATE   standard.sys_literaltodate(numerator IN VARCHAR2) RETURN DATE;
TBD
SYS_LITERALTODSINTERVAL   standard.sys_literaltodsinterval(numerator IN VARCHAR2, units IN VARCHAR2)
RETURN DSINTERVAL_UNCONSTRAINED;
TBD
SYS_LITERALTOTIME   standard.sys_literalToTime(numerator IN VARCHAR2) RETURN TIME_UNCONSTRAINED;
TBD
SYS_LITERALTOTIMESTAMP   standard.sys_literalToTimeStamp(numerator IN VARCHAR2) RETURN TIMESTAMP_UNCONSTRAINED;
TBD
SYS_LITERALTOTZTIME   standard.sys_literalToTZTime(numerator IN VARCHAR2) RETURN TIME_TZ_UNCONSTRAINED;
TBD
SYS_LITERALTOTZTIMESTAMP   standard.sys_literalToTZTimeStamp(numerator IN VARCHAR2) RETURN TIMESTAMP_TZ_UNCONSTRAINED;
TBD
SYS_LITERALTOYMINTERVAL   standard.sys_literalToYMInterval(numerator IN VARCHAR2, units IN VARCHAR2)
RETURN YMINTERVAL_UNCONSTRAINED;
TBD
TAN 2 Numeric Function
TANH 2 Numeric Function
TO_ANYLOB   standard.to_anylob(right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN CLOB CHARACTER SET RIGHT%CHARSET;
SELECT standard.to_anylob('Some value') FROM dual;
TO_BINARY_DOUBLE 3 Conversion Function
TO_BINARY_FLOAT 3 Conversion Function
TO_BLOB   Conversion Function
TO_CHAR 24 Conversion Function
TO_CLOB 2 Conversion Function
TO_DATE 4 Conversion Function
TO_DSINTERVAL 2 Conversion Function
TO_LABEL 2 standard.to_label(label IN VARCHAR2, format IN VARCHAR2)
RETURN MLSLABEL;

standard to_label(label IN VARCHAR2) RETURN MLSLABEL;
DECLARE
 l MLSLABEL;
BEGIN
  l := standard.to_label('ABC');
END;
/
TO_MULTI_BYTE   Conversion Function
TO_NCHAR 9 Conversion Function
TO_NCLOB 2 Conversion Function
TO_NUMBER 4 Conversion Function
TO_RAW   Conversion Function
TO_SINGLE_BYTE   Conversion Function
TO_TIME 4 function TO_TIME (RIGHT varchar2 character set any_cs) return time_unconstrained;

function TO_TIME(left varchar2 character set any_cs,
format varchar2 character set left%charset,
parms varchar2 character set left%charset)
return TIME_UNCONSTRAINED;

function TO_TIME(left varchar2 character set any_cs,
format varchar2 character set left%charset)
return TIME_UNCONSTRAINED;

function TO_TIME (RIGHT TIME_TZ_UNCONSTRAINED) return TIME_UNCONSTRAINED;
TO_TIMESTAMP 6 Conversion Function
TO_TIMESTAMP_TZ 6 Conversion Function
TO_TIME_TZ 4 function TO_TIME_TZ (RIGHT varchar2 character set any_cs) return TIME_TZ_UNCONSTRAINED;

function TO_TIME_TZ(left varchar2 character set any_cs,
format varchar2 character set left%charset,
parms varchar2 character set left%charset)
return TIME_TZ_UNCONSTRAINED;

function TO_TIME_TZ(left varchar2 character set any_cs,
format varchar2 character set left%charset)
return TIME_TZ_UNCONSTRAINED;

function TO_TIME_TZ (RIGHT TIME_UNCONSTRAINED) return TIME_TZ_UNCONSTRAINED;
TO_YMINTERVAL   Conversion Function
TRANSLATE 2 String Function
TRIM 2 String Function
TRUNC 6 Date Function and Numeric Function
TZ_OFFSET   Timestamp Function
UID   Miscellaneous Functions
UNISTR   Conversion Function
UPPER 2 String Function
"UROWID "   -- here's what the source code states:

function "UROWID " RETURN UROWID;
pragma builtin('UROWID ', 1, 209, 240); -- this had better never be called.
USER   Miscellaneous Functions
USERENV   Miscellaneous Functions
VALUE   Miscellaneous Functions
VSIZE 3 Date Function, Numeric Function, and String Function
XOR   Miscellaneous Functions
 
Miscellaneous Functions
Object Name Overloads Description
= 23 standard.=(left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;

standard.'=' (
left  IN VARCHAR2 CHARACTER SET ANY_CS,
right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'=' (left IN NUMBER, right IN NUMBER) RETURN BOOLEAN;

standard.'=' (left IN BINARY_FLOAT, right IN BINARY_FLOAT)
RETURN BOOLEAN;

standard.'=' (left IN BINARY_DOUBLE, right IN BINARY_DOUBLE)
RETURN BOOLEAN;

standard.'=' (left IN PLS_INTEGER, right IN PLS_INTEGER)
RETURN BOOLEAN;

standard.'=' (left IN DATE, right IN DATE) RETURN BOOLEAN;

standard.'=' (label1 IN MLSLABEL, label2 IN MLSLABEL)
RETURN BOOLEAN;

standard.'=' (left IN "<ADT_1>", right IN "<ADT_1>")
RETURN BOOLEAN;

standard.'=' (left IN REF "<ADT_1>", right IN REF "<ADT_1>")
RETURN BOOLEAN;

standard.'=' (left IN "<OPAQUE_1>", right IN "<OPAQUE_1>")
RETURN BOOLEAN;

standard.'='(collection1 IN "<TABLE_1>", collection2 IN "<TABLE_1>")
RETURN BOOLEAN;

standard.'=' (left IN UROWID, right IN UROWID) RETURN BOOLEAN;

standard.'=' (
left  IN CLOB CHARACTER SET ANY_CS,
right IN CLOB CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'=' (
left  IN CLOB CHARACTER SET ANY_CS,
right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'=' (
left  IN VARCHAR2 CHARACTER SET ANY_CS,
right IN CLOB CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'=' (
left  IN TIME_UNCONSTRAINED,
right IN TIME_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'=' (
left  IN TIMESTAMP_UNCONSTRAINED,
right IN TIMESTAMP_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'=' (
left  IN TIME_TZ_UNCONSTRAINED,
right IN TIME_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'=' (
left  IN TIMESTAMP_TZ_UNCONSTRAINED,
right IN TIMESTAMP_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'=' (
left  IN TIMESTAMP_LTZ_UNCONSTRAINED,
right IN TIMESTAMP_LTZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'=' (
left  IN YMINTERVAL_UNCONSTRAINED,
right IN YMINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'=' (
left  IN DSINTERVAL_UNCONSTRAINED,
right IN DSINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;
!= 24 standard.!=' (left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;

standard.'!='(
left  IN VARCHAR2 CHARACTER SET ANY_CS,
right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'!=' (left IN NUMBER, right IN NUMBER) RETURN BOOLEAN;

standard.'!=' (
left  IN TIME_UNCONSTRAINED,
right IN TIME_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'!=' (
left  IN TIMESTAMP_UNCONSTRAINED,
right IN TIMESTAMP_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'!=' (
left  IN TIME_TZ_UNCONSTRAINED,
right IN TIME_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'!=' (
left  IN YMINTERVAL_UNCONSTRAINED,
right IN YMINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'!=' (
left  IN DSINTERVAL_UNCONSTRAINED,
right IN DSINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'!=' (left  IN UROWID, right IN UROWID) RETURN BOOLEAN;

standard.'!=' (
left  IN TIMESTAMP_TZ_UNCONSTRAINED,
right IN TIMESTAMP_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'!=' (
left  IN TIMESTAMP_LTZ_UNCONSTRAINED,
right IN TIMESTAMP_LTZ_UNCONSTRAINED)
RETURN BOOLEAN;
~= 23 standard.'~='(left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;
< 21 standard.'<'(left in BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'<'(
left  IN VARCHAR2 CHARACTER SET ANY_CS,
RIGHT IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'<' (LEFT NUMBER, RIGHT NUMBER) RETURN BOOLEAN;

standard.'<' (LEFT TIME_UNCONSTRAINED, RIGHT TIME_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'<' (LEFT TIMESTAMP_UNCONSTRAINED, RIGHT TIMESTAMP_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'<' (LEFT TIME_TZ_UNCONSTRAINED, RIGHT TIME_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'<' (LEFT YMINTERVAL_UNCONSTRAINED, RIGHT YMINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'<' (LEFT DSINTERVAL_UNCONSTRAINED, RIGHT DSINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'<' (LEFT UROWID, RIGHT UROWID) RETURN BOOLEAN;

standard.'<' (LEFT TIMESTAMP_TZ_UNCONSTRAINED, RIGHT TIMESTAMP_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'<' (LEFT TIMESTAMP_LTZ_UNCONSTRAINED, RIGHT TIMESTAMP_LTZ_UNCONSTRAINED)
RETURN BOOLEAN;
<= 21 standard.'<='(left in BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'<='(left in VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET ANY_CS) RETURN BOOLEAN;

standard.'<=' (LEFT NUMBER, RIGHT NUMBER) RETURN BOOLEAN;
standard.'<=' (LEFT TIME_UNCONSTRAINED, RIGHT TIME_UNCONSTRAINED) RETURN BOOLEAN;
standard.'<=' (LEFT TIMESTAMP_UNCONSTRAINED, RIGHT TIMESTAMP_UNCONSTRAINED) RETURN BOOLEAN;
standard.'<=' (LEFT TIME_TZ_UNCONSTRAINED, RIGHT TIME_TZ_UNCONSTRAINED) RETURN BOOLEAN;

standard.'<=' (LEFT YMINTERVAL_UNCONSTRAINED, RIGHT YMINTERVAL_UNCONSTRAINED) RETURN BOOLEAN;

standard.'<=' (LEFT DSINTERVAL_UNCONSTRAINED, RIGHT DSINTERVAL_UNCONSTRAINED) RETURN BOOLEAN;

standard.'<=' (LEFT UROWID, RIGHT UROWID) RETURN BOOLEAN;

standard.'<=' (LEFT TIMESTAMP_TZ_UNCONSTRAINED,
RIGHT TIMESTAMP_TZ_UNCONSTRAINED) RETURN BOOLEAN;

standard.'<=' (LEFT TIMESTAMP_LTZ_UNCONSTRAINED, RIGHT TIMESTAMP_LTZ_UNCONSTRAINED) RETURN BOOLEAN;
> 21 standard.'>'(left IN BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'>'(
left  IN VARCHAR2 CHARACTER SET ANY_CS,
right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'>' (left IN NUMBER, right IN NUMBER)
RETURN BOOLEAN;

standard.'>' (left IN TIME_UNCONSTRAINED, right IN TIME_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>' (left IN TIMESTAMP_UNCONSTRAINED, right IN TIMESTAMP_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>' (left IN TIME_TZ_UNCONSTRAINED, right IN TIME_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>' (left IN YMINTERVAL_UNCONSTRAINED, right IN YMINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>' (
left  IN DSINTERVAL_UNCONSTRAINED,
right IN RIGHT DSINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>' (left IN UROWID, right IN UROWID) RETURN BOOLEAN;

standard.'>' (
left  IN TIMESTAMP_TZ_UNCONSTRAINED,
right IN TIMESTAMP_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>' (
left  IN TIMESTAMP_LTZ_UNCONSTRAINED,
right IN TIMESTAMP_LTZ_UNCONSTRAINED)
RETURN BOOLEAN;
>= 21 standard.'>='(left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;

standard.'>='(
left  IN VARCHAR2 CHARACTER SET ANY_CS,
right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;

standard.'>=' (left IN NUMBER, right IN NUMBER) RETURN BOOLEAN;

standard.'>=' (left IN TIME_UNCONSTRAINED, right IN TIME_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>=' (
left  IN TIMESTAMP_UNCONSTRAINED,
right IN TIMESTAMP_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>=' (
left  IN TIME_TZ_UNCONSTRAINED,
right IN TIME_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>=' (
left  IN YMINTERVAL_UNCONSTRAINED,
right IN YMINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>=' (
left  IN DSINTERVAL_UNCONSTRAINED,
right IN DSINTERVAL_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>=' (
left  IN UROWID,
right IN UROWID)
RETURN BOOLEAN;

standard.'>=' (
left  IN TIMESTAMP_TZ_UNCONSTRAINED,
right IN TIMESTAMP_TZ_UNCONSTRAINED)
RETURN BOOLEAN;

standard.'>=' (
left  IN TIMESTAMP_LTZ_UNCONSTRAINED,
right IN TIMESTAMP_LTZ_UNCONSTRAINED)
RETURN BOOLEAN;
|| 2 standard.'||' (
left  IN VARCHAR2 CHARACTER SET ANY_CS,
right IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN VARCHAR2 CHARACTER SET LEFT%CHARSET;

standard.'||' (
left  IN CLOB CHARACTER SET ANY_CS,
right IN CLOB CHARACTER SET ANY_CS)
RETURN CLOB CHARACTER SET LEFT%CHARSET;
** 2 Oracle Operators
ALL   function '=ALL' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '!=ALL' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '<ALL' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '<=ALL' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '>ALL' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;

function '=ALL' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '=ALL' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '=ALL' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '!=ALL' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '!=ALL' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '!=ALL' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '<ALL' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '<ALL' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '<ALL' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '<=ALL' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '<=ALL' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '<=ALL' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '>ALL' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '>ALL' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '>ALL' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '>=ALL' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '>=ALL' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '>=ALL' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;
ANY 25 function '=ANY' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '!=ANY' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '<ANY' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '<=ANY' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '>ANY' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '>=ANY' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;

function '=ANY' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '=ANY' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '=ANY' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '!=ANY' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '!=ANY' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '!=ANY' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '<ANY' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '<ANY' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '<ANY' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '<=ANY' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '<=ANY' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '<=ANY' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '>ANY' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '>ANY' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '>ANY' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '>=ANY' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '>=ANY' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '>=ANY' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;
IS A SET   standard.'IS A SET' (collection IN "<TABLE_1>") RETURN BOOLEAN;
IS DANGLING   Nested Table Constraints
IS EMPTY   standard.'IS EMPTY' (collection IN "<TABLE_1>") RETURN BOOLEAN;
IS INFINITE 3 Conditions
IS NAN 3 Conditions
IS NOT A SET   standard.'IS NOT A SET' (collection IN "<TABLE_1>") RETURN BOOLEAN;
IS NOT DANGLING   Nested Table Constraints
IS NOT EMPTY   standard.'IS NOT EMPTY' (collection IN "<TABLE_1>") RETURN BOOLEAN;
IS NOT INFINITE 3 Conditions
IS NOT NAN 3 Conditions
IS NOT NULL 23 standard.'IS NOT NULL' (d     IN DATE) RETURN BOOLEAN;
standard.'IS NOT NULL' (s     IN VARCHAR2 CHARACTER SET ANY_CS) RETURN BOOLEAN;
standard.'IS NOT NULL' (n     IN NUMBER) RETURN BOOLEAN;
standard.'IS NOT NULL' (n     IN BINARY_DOUBLE) RETURN BOOLEAN;
standard.'IS NOT NULL' (n     IN BINARY_FLOAT) RETURN BOOLEAN;
standard.'IS NOT NULL' (i     IN PLS_INTEGER) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN BOOLEAN) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN REF "<ADT_1>") RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN "<COLLECTION_1>") RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN "<REF_CURSOR_1>") RETURN BOOLEAN;
standard.'IS NOT NULL' (n     IN BFILE) RETURN BOOLEAN;
standard.'IS NOT NULL' (n     IN CLOB CHARACTER SET ANY_CS) RETURN BOOLEAN;
standard.'IS NOT NULL' (n     IN BLOB) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN TIME_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN TIME_TZ_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN TIMESTAMP_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN TIMESTAMP_TZ_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN TIMESTAMP_LTZ_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN YMINTERVAL_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN DSINTERVAL_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NOT NULL' (b     IN "<ADT_1>") RETURN BOOLEAN;
standard.'IS NOT NULL' (label IN MLSLABEL) RETURN BOOLEAN;
standard 'IS NOT NULL' (u     IN UROWID) RETURN BOOLEAN;
IS NULL 23 standard.'IS NULL' (b     IN BOOLEAN) RETURN BOOLEAN;
standard.'IS NULL' (n     IN NUMBER) RETURN BOOLEAN;
standard.'IS NULL' (n     IN BINARY_DOUBLE) RETURN BOOLEAN;
standard.'IS NULL' (n     IN BINARY_FLOAT) RETURN BOOLEAN;
standard.'IS NULL' (i     IN PLS_INTEGER) RETURN BOOLEAN;
standard.'IS NULL' (d     IN DATE) RETURN BOOLEAN;
standard.'IS NULL' (s     IN VARCHAR2 CHARACTER SET ANY_CS) RETURN BOOLEAN;
standard.'IS NULL' (n     IN CLOB CHARACTER SET ANY_CS) RETURN BOOLEAN;
standard.'IS NULL' (n     IN BLOB) RETURN BOOLEAN;
standard.'IS NULL' (n     IN BFILE) RETURN BOOLEAN;
standard.'IS NULL' (b     IN YMINTERVAL_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN  DSINTERVAL_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN TIMESTAMP_LTZ_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN TIMESTAMP_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN TIMESTAMP_TZ_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN TIME_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN TIME_TZ_UNCONSTRAINED) RETURN BOOLEAN;
standard.'IS NULL' (b     IN REF "<ADT_1>") RETURN BOOLEAN;
standard.'IS NULL' (b     IN "<COLLECTION_1>") RETURN BOOLEAN;
standard.'IS NULL' (b     IN "<REF_CURSOR_1>") RETURN BOOLEAN;
standard.'IS NULL' (b     IN "<ADT_1>") RETURN BOOLEAN;
standard.'IS NULL' (u     IN UROWID) RETURN BOOLEAN;
standard.'IS NULL' (label IN MLSLABEL) RETURN BOOLEAN;
NOT   standard.'NOT'(right IN BOOLEAN) RETURN BOOLEAN;
SOME 24 function '=SOME' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '!=SOME' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '<SOME' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '<=SOME' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '>SOME' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;
function '>=SOME' (LEFT "<ADT_1>", RIGHT "<ADT_1>") return BOOLEAN;

function '=SOME' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '=SOME' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '=SOME' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '!=SOME' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '!=SOME' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '!=SOME' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '<SOME' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '<SOME' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '<SOME' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '<=SOME' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '<=SOME' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '<=SOME' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '>SOME' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '>SOME' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '>SOME' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;

function '>=SOME' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET LEFT%CHARSET) return BOOLEAN;

function '>=SOME' (LEFT DATE, RIGHT DATE) return BOOLEAN;

function '>=SOME' (LEFT NUMBER, RIGHT NUMBER) return BOOLEAN;
 
Procedures
Object Name Overloads Description
COMMIT   standard.commit();
exec standard.commit();
exec standard.commit;
COMMIT;
COMMIT_CM   standard.commit_cm(vc VARCHAR2)
exec standard.commit_cm('this is a commit comment');

COMMIT COMMENT 'Committing a test record';
CONTINUE   PL/SQL Function
exec standard.continue;

exec continue;

For proper usage: Click Here
ROLLBACK_NR   standard.rollback_nr;
See SAVEPOINT Demo Below
ROLLBACK_SV   standard.rollback_sv(save_point CHAR);
See SAVEPOINT Demo Below
SAVEPOINT   standard.savepoint(save_point CHAR);
CREATE TABLE t (
testcol VARCHAR2(1));

INSERT INTO t VALUES ('A');

exec standard.savepoint('B')

INSERT INTO t VALUES ('C');

SELECT * FROM t;

exec standard.rollback_sv('B');

SELECT * FROM t;

exec standard.rollback_nr('B');

SELECT * FROM t;
SET_TRANSACTION_USE   standard.set_transaction_use(vc VARCHAR2)
exec standard.set_transaction('READ WRITE');

Related Topics
Built-In Functions
Conditions
DBMS_STANDARD
Exception Handling
Packages
Transactions

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved