Oracle STANDARD
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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,446 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 1 String Function
ASCIISTR 1 Conversion Function
ASIN 2 Numeric Function
ATAN 2 Numeric Function
ATAN2 2 Numeric Function
BFILENAME 1 Conversion Function
BITAND 2 Numeric Function
CARDINALITY 1 Collection Function
CEIL 3 Numeric Function
CHARTOROWID 1 Conversion Function
CHR 1 String Function
COALESCE 1 String Function
COMPOSE 1 Conversion Function
CONCAT 2 String Function
CONVERT 4 Conversion Function and String Function
COS 2 Numeric Function
COSH 2 Numeric Function
CUBE 1 Rollup and Cube
CURRENT_DATE 1 Date Function
CURRENT_TIME 1 standard.current_time RETURN TIME_TZ_UNCONSTRAINED;
Not-functional as SELECT current_time FROM dual;
CURRENT_TIMESTAMP 1 Timestamp Function
DBTIMEZONE 1 Timestamp Function
DECODE 11 DECODE and CASE
DECOMPOSE 1 Conversion Function
DEREF 2 Nested Table Constraints
DUMP 3 Date Function, Numeric Function, and String Function
EMPTY_BLOB 1 standard.empty_blob RETURN BLOB;
DBMS_LOB
EMPTY_CLOB 1 standard.empty_clob RETURN CLOB;
DBMS_LOB
EXISTS 1 Conditions
EXP 2 Numeric Function
FLOOR 3 Numeric Function
FROM_TZ 1 Timestamp Function
GLB 1 -- group function
standard.glb(label IN MLSLABEL) RETURN MLSLABEL;
TBD
GREATEST 13 Date Function, Numeric Function, and String Function
GREATEST_LB 1 -- vararg routines - icds in stdbdy
standard.greatest_lb(pattern IN MLSLABEL) RETURN MLSLABEL;
TBD
GROUPING 3 Rollup and Cube
HEXTORAW 2 Conversion Function
INITCAP 1 String Function
INSTR 2 String Function
INSTR2 1 String Function
INSTR4 1 String Function
INSTRB 2 String Function
INSTRC 1 String Function
ISNCHAR

Implemented as a icd call, returning  TRUE if nchar, else FALSE		 1 -- 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;
/
IS_JSON 1 JSON
IS_NOT_JSON 1 JSON
JSON_ARRAY 1 JSON
JSON_EQUAL 1 JSON
JSON_EXISTS 1 JSON
JSON_OBJECT 1 JSON
JSON_QUERY 1 JSON
JSON_SCALAR 1 JSON
JSON_SERIALIZE 1 JSON
JSON_VALUE 1 JSON
LAST_DAY 1 Date Function
LEAST 13 Date Function, Numeric Function, and String Function
LEAST_UB 1 -- vararg routines - icds in stdbdy
standard.least_ub(pattern IN MLSLABEL) RETURN MLSLABEL;
TBD
LENGTH 3 Numeric Function and String Function
LENGTH2 1 Numeric Function
LENGTH4 1 Numeric Function
LENGTHB 3 Numeric Function
LENGTHC 1 Numeric Function
LEVEL 1 standard.level RETURN NUMBER;
Connect By
LIKE 4 Conditions
LIKEC 2 Conditions
LIKE2 2 Conditions
LIKE4 2 Conditions
LN 2 Numeric Function
LOCALTIME 1 Timestamp Function
LOCALTIMESTAMP 1 Timestamp Function
LOG 2 Numeric Function
LOWER 2 String Function
LPAD 4 String Function
LTRIM 4 String Function
LUB 1 -- group function
standard.lub(label IN MLSLABEL) RETURN MLSLABEL
TBD
MOD 3 Numeric Function
MONTHS_BETWEEN 1 Date Function
MULTISET_EXCEPT_ALL 1 Operators
MULTISET_EXCEPT_DISTINCT 1 Operators
MULTISET_INTERSECT_ALL 1 Operators
MULTISET_INTERSECT_DISTINCT 1 Operators
MULTISET_UNION_ALL 1 Operators
MULTISET_UNION_DISTINCT 1 Operators
NANVL 3 Numeric Function
NCHARTOROWID 1 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 1 standard.nchr(n IN PLS_INTEGER) RETURN NVARCHAR2;
SELECT(nchr(68) || nchr(65) || nchr(78))
FROM dual;
NEW_TIME 1 Date Function
NEXT_DAY 1 Date Function
NHEXTORAW 1 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 1 Character Set Functions
NLS_CHARSET_ID 1 Character Set Functions
NLS_CHARSET_NAME 1 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 1 standard.nullfn(str IN VARCHAR2) RETURN RAW;
SELECT standard.nullfn('A') FROM dual;
NULLIF 4 Miscellaneous Function
NUMTODSINTERVAL 1 Conversion Function
NUMTOYMINTERVAL 1 Conversion Function
NVL 21 Miscellaneous Function
NVL2 1 Miscellaneous Function
POWER 2 Numeric Function
PRIOR 3 Connect By
RAWTOHEX 1 Conversion Function
RAWTONHEX 1 Conversion Function
REF 1 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 1 Rollup and Cube
ROUND 6 Numeric Function
ROUND_TIES_TO_EVEN 1 Undocumented
ROWID 1 Here's what Oracle's 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 1 Conversion Function
ROWIDTONCHAR 1 Conversion Function
ROWLABEL 1 standard.rowlabel RETURN MLSLABEL; -- defines a pseudocolumn
TBD
ROWNUM 1 standard.rownum RETURN NUMBER;
Pseudocolumns
RPAD 4 String Function
RTRIM 4 String Function
SESSIONTIMEZONE 1 Timestamp Functions
SET 1 standard.set(collection IN "<TABLE_1>") RETURN "<TABLE_1>";
TBD
SIGN 4 Numeric Function
SIN 2 Numeric Function
SINH 2 Numeric Function
SOUNDEX 1 String Function
SQLCODE 1 Exception Handling
SQLERRM 2 Exception Handling
SQRT 3 Numeric Function
SUBMULTISET 1 Conditions
SUBSTR 2 String Function
SUBSTR2 1 String Function
SUBSTR4 1 String Function
SUBSTRB 2 String Function
SUBSTRC 1 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"
(the leading space is valid and required)		 1 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_JSON"
(the leading space is valid and required)		 1 standard." SYS$STANDARD_JSON" RETURN VARCHAR2;
SQL> DECLARE
x VARCHAR2(60);
BEGIN
x := standard." SYS$STANDARD_JSON";
END;
/
x := standard." SYS$STANDARD_JSON";
*
ERROR at line 4:
ORA-06550: line 4, column 18:
PLS-00306: wrong number or types of arguments in call to ' SYS$STANDARD_JSON'
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
" SYS$STANDARD_TRANSLATE"
(the leading space is valid and required)		 1 standard." SYS$STANDARD_TRANSLATE" (
src IN VARCHAR2 CHARACTER SET ANY_CS,
csn IN 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"
(the leading space is valid and required)		 6 function " SYS$STANDARD_TRIM"(v IN VARCHAR2 CHARACTER SET ANY_CS)
return VARCHAR2 CHARACTER SET v%CHARSET;

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

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

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

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

function " SYS$STANDARD_TRIM"(
STR1   IN CLOB CHARACTER SET ANY_CS ,
TSET   IN CLOB CHARACTER SET STR1%CHARSET,
TRFLAG IN PLS_INTEGER)
return CLOB CHARACTER SET STR1%CHARSET;
" SYS$YMINTERVALSUBTRACT"
(the leading space is valid and required)		 1 function " SYS$YMINTERVALSUBTRACT"(
LEFT  IN TIMESTAMP_UNCONSTRAINED,
RIGHT IN TIMESTAMP_UNCONSTRAINED)
return YMINTERVAL_UNCONSTRAINED ;
SYSDATE 1 Date Function
SYSTIMESTAMP 1 Timestamp Function
SYS_AT_TIME_ZONE 2 Timestamp Function
SYS_CONTEXT 2 Environment Function
SYS_EXTRACT_UTC 1 Timestamp Function
SYS_GUID 1 Miscellaneous Functions
SYS_LITERALTODATE 1 standard.sys_literaltodate(numerator IN VARCHAR2) RETURN DATE;
TBD
SYS_LITERALTODSINTERVAL 1 standard.sys_literaltodsinterval(
numerator IN VARCHAR2,
units IN VARCHAR2)
RETURN DSINTERVAL_UNCONSTRAINED;
TBD
SYS_LITERALTOTIME 1 standard.sys_literalToTime(numerator IN VARCHAR2) RETURN TIME_UNCONSTRAINED;
TBD
SYS_LITERALTOTIMESTAMP 1 standard.sys_literalToTimeStamp(numerator IN VARCHAR2) RETURN TIMESTAMP_UNCONSTRAINED;
TBD
SYS_LITERALTOTZTIME 1 standard.sys_literalToTZTime(numerator IN VARCHAR2) RETURN TIME_TZ_UNCONSTRAINED;
TBD
SYS_LITERALTOTZTIMESTAMP 1 standard.sys_literalToTZTimeStamp(numerator IN VARCHAR2) RETURN TIMESTAMP_TZ_UNCONSTRAINED;
TBD
SYS_LITERALTOYMINTERVAL 1 standard.sys_literalToYMInterval(numerator IN VARCHAR2, units IN VARCHAR2)
RETURN YMINTERVAL_UNCONSTRAINED;
TBD
TAN 2 Numeric Function
TANH 2 Numeric Function
TO_ANYLOB 1 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 1 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 1 Conversion Function
TO_SINGLE_BYTE 1 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 1 Conversion Function
TRANSLATE 2 String Function
TRIM 2 String Function
TRUNC 6 Date Function and Numeric Function
TZ_OFFSET 1 Timestamp Function
UID 1 Miscellaneous Functions
UNISTR 1 Conversion Function
UPPER 2 String Function
"UROWID " 1 -- here's what the source code states ... the comment in red is Oracle's not mine
function "UROWID " RETURN UROWID;
pragma builtin('UROWID ', 1, 209, 240); -- this had better never be called.
USER 1 Miscellaneous Functions
USERENV 1 Miscellaneous Functions
VALUE 1 Miscellaneous Functions
VSIZE 3 Date Function, Numeric Function, and String Function
XOR 1 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 IN 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 IN CHAR);
See SAVEPOINT Demo Below
SAVEPOINT   standard.savepoint(save_point IN 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 IN VARCHAR2)
exec standard.set_transaction('READ WRITE');

Related Topics
Built-in Functions
Built-in Packages
Conditions
DBMS_STANDARD
Exception Handling
Transactions
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx