Oracle Standard
Version 11.2.0.2
 
General Information
Source {ORACLE_HOME}/rdbms/admin/stdspec.sql
First Availability 7.3.4
Constants
Name Data Type Value
BINARY_FLOAT_NAN
BINARY_FLOAT_INFINITY 
BINARY_FLOAT_MAX_NORMAL
BINARY_FLOAT_MIN_NORMAL 
BINARY_FLOAT_MAX_SUBNORMAL 
BINARY_FLOAT_MIN_SUBNORMAL 

BINARY_DOUBLE_NAN
BINARY_DOUBLE_INFINITY 
BINARY_DOUBLE_MAX_NORMAL 
BINARY_DOUBLE_MIN_NORMAL 
BINARY_DOUBLE_MAX_SUBNORMAL 
BINARY_DOUBLE_MIN_SUBNORMAL		 BINARY_FLOAT
BINARY_FLOAT
BINARY_FLOAT
BINARY_FLOAT
BINARY_FLOAT
BINARY_FLOAT

BINARY_DOUBLE
BINARY_DOUBLE
BINARY_DOUBLE
BINARY_DOUBLE
BINARY_DOUBLE
BINARY_DOUBLE		  
Data Types and Subtypes type BOOLEAN is (FALSE, TRUE);

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;

type MLSLABEL is new CHAR_BASE;

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_FLOAT is NUMBER;
 subtype BINARY_DOUBLE is NUMBER;

 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;

 type VARCHAR2 is NEW CHAR_BASE;
 type UROWID IS NEW CHAR_BASE;
 subtype VARCHAR is VARCHAR2;
 subtype STRING is VARCHAR2;
 subtype LONG is VARCHAR2(32760);
 subtype RAW is VARCHAR2;
 subtype "LONG RAW" is RAW(32760);
 subtype ROWID is VARCHAR2(256);
 -- ANSI fixed-length char
 -- Define synonyms for CHAR and CHARN.
 subtype CHAR is VARCHAR2;
 subtype CHARACTER is CHAR;
 -- Verbose and NCHAR type names
 subtype "CHARACTER VARYING" is VARCHAR;
 subtype "CHAR VARYING" is VARCHAR;
 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;
-- Large object data types.
-- binary, character, binary file.

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;

subtype pls_integer is binary_integer;

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;

-- The following data types are generics, used specially within package
-- STANDARD and some other Oracle packages. They are protected against
-- other use; sorry. True generic types are not yet part of the language.

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 the
-- runtime (for more details about the array attributes, please
-- see Bulk Binds document).
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 the 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);

 -- 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;
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'STANDARD'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'STANDARD';
Exceptions that can be raised
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
Security Model execute is granted to PUBLIC
 
Functions
Object Name Overloads Description
ABS 4 Numeric Function
ACOS 2 Numeric Function
ADD_MONTHS   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   Conversion Function
CHR   String Function
COMPOSE   Conversion Function
CONCAT 2 String Function
CONVERT 4 Conversion Function and String Function
COS 2 Numeric Function
COSH 2 Numeric Function
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 Mutli-use Function
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   standard.exists RETURN BOOLEAN;
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 Numeric 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 Numeric 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 Function
LIKE   Conditions
LIKEC   Conditions
LIKE2   Conditions
LIKE4   Conditions
LN   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   Numeric Function
MONTHS_BETWEEN   Date Function
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
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 20 Miscellaneous Function
POWER 2 Numeric Function
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
REPLACE 2 Translate - Replace
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 Function
SQLERRM 2 Exception Handling Function
SQRT 3 Numeric Function
SUBSTR 2 String Function
SUBSTR2   String Function
SUBSTR4   String Function
SUBSTRB 2 String Function
SUBSTRC   String Function
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
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 9 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_TIMESTAMP 6 Conversion Function
TO_TIMESTAMP_TZ 6 Conversion Function
TO_YMINTERVAL   Conversion Function
TRANSLATE   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.

I suspect this warning should be taken seriously though it does beg the question of why it was exposed.
USER   Miscellaneous Functions
USERENV   Miscellaneous Functions
VALUE   Miscellaneous Functions
VSIZE 3 Date Function, Numeric Function, and String Function
XOR   standard.XOR(left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF xor(TRUE, TRUE) THEN
    dbms_output.put_line('TRUE-TRUE Returns TRUE');
  END IF;
  IF xor(TRUE, FALSE) THEN
    dbms_output.put_line('TRUE-FALSE Returns TRUE');
  END IF;
END;
/
 
Miscellaneous Functions
=   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;
!=   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;
<>   standard.'<>'(left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;
~=   standard.'~='(left IN BOOLEAN, right IN BOOLEAN) RETURN BOOLEAN;
<   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;
<=   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;
>
11		 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;
>= 11 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
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   Conditions
IS NAN   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   Conditions
IS NOT NAN   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;
 
Procedures
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
Transactions
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: © 2012 Daniel A. Morgan All Rights Reserved