CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle STANDARD

Version 11.1
 
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);

/********** Add new types or subtypes here **********/

/********** Predefined constants **********/

BINARY_FLOAT_NAN constant BINARY_FLOAT;
BINARY_FLOAT_INFINITY constant BINARY_FLOAT;
BINARY_FLOAT_MAX_NORMAL constant BINARY_FLOAT;
BINARY_FLOAT_MIN_NORMAL constant BINARY_FLOAT;
BINARY_FLOAT_MAX_SUBNORMAL constant BINARY_FLOAT;
BINARY_FLOAT_MIN_SUBNORMAL constant BINARY_FLOAT;
BINARY_DOUBLE_NAN constant BINARY_DOUBLE;
BINARY_DOUBLE_INFINITY constant BINARY_DOUBLE;
BINARY_DOUBLE_MAX_NORMAL constant BINARY_DOUBLE;
BINARY_DOUBLE_MIN_NORMAL constant BINARY_DOUBLE;
BINARY_DOUBLE_MAX_SUBNORMAL constant BINARY_DOUBLE;
BINARY_DOUBLE_MIN_SUBNORMAL constant BINARY_DOUBLE;
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 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 Numeric Function and 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 Numeric Function
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 9 Mutli-use Function
DECOMPOSE 1 Conversion Function
DEREF 1 Object Function
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 standard.exists RETURN BOOLEAN;
EXP 2 Numeric Function
FLOOR 3 Numeric Function
FROM_TZ 1 Timestamp Function
GLB 1 -- group function
standard.geatest_lb(label MLSLABEL) RETURN MLSLABEL
TBd
GREATEST 9 Numeric Function
GREATEST_LB 1 -- vararg routines - icds in stdbdy
standard.geatest_lb(pattern MLSLABEL) RETURN MLSLABEL
TBD
GROUPING 3 Group By Function
HEXTORAW 1 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

1
-- implemented as a icd call, return TRUE if nchar, otherwise FALSE
standard.isnchar(c 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 1 Date Function
LEAST 9 Numeric Function
LEAST_UB 1 -- vararg routines - icds in stdbdy
standard.least_ub(pattern 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 Function
LN 1 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 MLSLABEL) RETURN MLSLABEL
TBD
MONTHS_BETWEEN 1 Date Function
NANVL 3 Numeric Function

NCHARTOROWID

1
standard.nchartorowid(str 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.nchartorowid(n BINARY_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 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 Miscellaneous Functions
NLS_CHARSET_ID 1 Miscellaneous Functions
NLS_CHARSET_NAME 1 Miscellaneous Functions
NLS_INITCAP 2 String Function
NLS_LOWER 4 String Function
NLS_UPPER 4 String Function
NULLFN 1 standard.nullfn(str VARCHAR2) RETURN RAW;
SELECT standard.nullfn('F30201') FROM dual;
NULLIF 4 Null Handling Function
NUMTODSINTERVAL 1 Conversion Function
NUMTOYMINTERVAL 1 Conversion Function
NVL 9 Null Handling Function
POWER 2 Numeric Function
RAWTOHEX 1 Conversion Function
RAWTONHEX 1 Conversion Function
REF 1 Object Function
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 String Function
ROLLUP 1 Group By Function
ROUND 6 Numeric Function

ROWID

1
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 1 Conversion Function
ROWIDTONCHAR 1 Conversion Function
ROWLABEL 1 standard.rowlabel RETURN MLSLABEL; -- defines a pseudocolumn
TBD
ROWNUM 1 standard.rownum RETURN NUMBER;
SELECT rownum, table_name
FROM user_tables;
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 Function
SQLERRM 2 Exception Handling Function
SQRT 3 Numeric Function
SUBSTR 2 String Function
SUBSTR2 1 String Function
SUBSTR4 1 String Function
SUBSTRB 2 String Function
SUBSTRC 1 String Function
SYS$LOB_REPLICATION 2 standard.sys$lob_replication(x BLOB) RETURN BLOB;

standard.sys$lob_replication(x CLOB CHARACTER SET ANY_CS)
RETURN CLOB CHARACTER SET x%CHARSET;
TBD
SYSDATE 1 Date Function
SYSTIMESTAMP 1 Timestamp Function

SYS_AT_TIME_ZONE

2
standard.sys_at_time_zone(
t time_tz_unconstrained, i VARCHAR2)
RETURN time_tz_unconstrained;

standard.sys_at_time_zone(
t timestamp_tz_unconstrained, i VARCHAR2)
RETURN timestamp_tz_unconstrained;
SELECT *
FROM gv$timezone_names;

SELECT standard.sys_at_time_zone(SYSTIMESTAMP, 'US/Pacific')
FROM dual;

SELECT standard.sys_at_time_zone(SYSTIMESTAMP, 'Asia/Singapore')
FROM dual;
SYS_CONTEXT 2 Environment Function
SYS_EXTRACT_UTC 1 Timestamp Function
SYS_GUID 1 Miscellaneous Functions
SYS_LITERALTODATE 1 standard.sys_literaltodate(numerator VARCHAR2) RETURN DATE;
TBD
SYS_LITERALTODSINTERVAL 1 standard.sys_literaltodsinterval(
numerator VARCHAR2, units VARCHAR2)
RETURN DSINTERVAL_UNCONSTRAINED;
TBD
SYS_LITERALTOTIME 1 standard.SYS_LITERALTOTIME(numerator VARCHAR2)
return TIME_UNCONSTRAINED;
TBD
SYS_LITERALTOTIMESTAMP 1 standard.sys_literaltotimestamp(numerator VARCHAR2)
RETURN TIMESTAMP_UNCONSTRAINED;
TBD
SYS_LITERALTOTZTIME 1 standard.SYS_LITERALTOTZTIME(numerator VARCHAR2)
return TIME_TZ_UNCONSTRAINED;
TBD
SYS_LITERALTOTZTIMESTAMP 1 standard.sys_literaltotztimestamp(numerator VARCHAR2)
RETURN TIMESTAMP_TZ_UNCONSTRAINED;
TBD
SYS_LITERALTOYMINTERVAL 1 standard.sys_literaltoyminterval(
numerator VARCHAR2, units VARCHAR2)
RETURN YMINTERVAL_UNCONSTRAINED;
TBD
TAN 2 Numeric Function
TANH 2 Numeric Function
TO_ANYLOB 1 standard.to_anylob(right VARCHAR2 CHARACTER SET ANY_CS)
RETURN CLOB CHARACTER SET RIGHT%CHARSET;
SELECTD 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 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 VARCHAR2, format VARCHAR2 )
RETURN MLSLABEL;

standard to_label(label VARCHAR2 ) RETURN MLSLABEL;
DECLARE
 l MLSLABEL;
BEGIN
  l := standard.to_label('ABC');
END;
/
TO_MULTI_BYTE 1 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 Conversion Function
TO_TIMESTAMP 6 Conversion Function
TO_TIMESTAMP_TZ 6 Conversion Function
TO_TIME_TZ 4 Conversion Function
TO_YMINTERVAL 1 Conversion Function
TRANSLATE 1 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:

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 1 Miscellaneous Functions
USERENV 1 Miscellaneous Functions
VALUE 1 Miscellaneous Functions
VSIZE 3 Date Function, Numeric Function, and String Function

XOR

1
standard.XOR (LEFT BOOLEAN, RIGHT 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;
/
 
Boolean Functions
=   standard.=(LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'=' (LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET ANY_CS) return BOOLEAN;
!=   standard.!=' (LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'!='(LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET ANY_CS) return BOOLEAN;
<>   standard.'<>'(LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;
~=   standard.'~='(LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;
<   standard.'<'(LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

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

standard.'<='(LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET ANY_CS) return BOOLEAN;
>   standard.'>'(LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'>'(LEFT VARCHAR2 CHARACTER SET ANY_CS,
RIGHT VARCHAR2 CHARACTER SET ANY_CS) return BOOLEAN;
>=   standard.'>='(LEFT BOOLEAN, RIGHT BOOLEAN) RETURN BOOLEAN;

standard.'>='(
left  VARCHAR2 CHARACTER SET ANY_CS,
right VARCHAR2 CHARACTER SET ANY_CS)
RETURN BOOLEAN;
||   standard.'||' (
left  VARCHAR2 CHARACTER SET ANY_CS,
right VARCHAR2 CHARACTER SET ANY_CS)
RETURN VARCHAR2 CHARACTER SET LEFT%CHARSET;
IS A SET   standard.'IS A SET' (
IS EMPTY   standard.'IS EMPTY' (
IS NOT A SET   standard.'IS NOT A SET' (
IS NOT NULL   standard.'IS NOT NULL' (b BOOLEAN) RETURN BOOLEAN;
IS NULL   standard.'IS NULL' (b BOOLEAN) RETURN BOOLEAN;
NOT   standard.'NOT' (right BOOLEAN) return BOOLEAN;
 
Procedures
COMMIT 1 standard.commit()
COMMIT;
COMMIT_CM 1 standard.commit_cm(vc VARCHAR2)
TBD

CONTINUE

1
PL/SQL Function
exec standard.continue;

exec continue;

For proper usage: Click Here
ROLLBACK_NR 1 standard.rollback_nr;
See SAVEPOINT Demo Below
ROLLBACK_SV 1 standard.rollback_sv(save_point CHAR);
See SAVEPOINT Demo Below

SAVEPOINT

1
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 1 standard.set_transaction_use(vc VARCHAR2)
TBD
 
Related Topics
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [74 users online]    © 2010 psoug.org