The usage of _ plsql function in mysql 02/14 Update SLTechnology News&Howtos

The usage of _ plsql function in mysql

2025-02-14 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)05/31 Report--

This article focuses on "the use of the _ plsql function in mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the usage of the _ plsql function in mysql.

SQL >-package encapsulation

SQL > create or replace package dbms_pack1

2 is

3 function gte_sal return number

4 procedure delete_tab (vtab varchar2)

5 end

6 /

Package created.

SQL >-- create the package

SQL > create or replace package body dbms_pack1

2 is

3 function get_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 /

Warning: Package Body created with compilation errors.

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

4 PLS-00103 3: Encountered the symbol "AS" when expecting one of the

Following:

Begin end function pragma procedure subtype type

Current cursor delete exists prior

9 + 6 PLS-00103: Encountered the symbol "end-of-file" when expecting

One of the following:

End not pragma final instantiable order overriding static

Member constructor map

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function get_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 * end

SQL > /

Warning: Package Body created with compilation errors.

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

9 + 6 PLS-00103: Encountered the symbol "end-of-file" when expecting

One of the following:

Begin end function pragma procedure

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function get_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 * end

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

9 + 6 PLS-00103: Encountered the symbol "end-of-file" when expecting

One of the following:

Begin end function pragma procedure

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function get_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 * end

SQL > /

Warning: Package Body created with compilation errors.

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function get_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 * end

11 /

Warning: Package Body created with compilation errors.

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

3 PLS-00323 10: subprogram or cursor 'GTE_SAL' is declared in a

Package specification and must be defined in the package body

4 PLS-00323 11: subprogram or cursor 'DELETE_TAB' is declared in a

Package specification and must be defined in the package body

7/6 PL/SQL: SQL Statement ignored

7/32 PL/SQL: ORA-00942: table or view does not exist

SQL >

SQL > l

1 create or replace package body dbms_pack1

2 is

3 function get_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 * end

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 * end

SQL > /

Warning: Package Body created with compilation errors.

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

4 PLS-00323 11: subprogram or cursor 'DELETE_TAB' is declared in a

Package specification and must be defined in the package body

7/6 PL/SQL: SQL Statement ignored

7/32 PL/SQL: ORA-00942: table or view does not exist

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 procedure delete_tab (vtab varchar2)

11 is

12 begin

13 execute immediate 'delete' | | vtab

14 * end

15 /

Warning: Package Body created with compilation errors.

SQL > l

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 procedure delete_tab (vtab varchar2)

11 is

12 begin

13 execute immediate 'delete' | | vtab

14 * end

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

14 + 4 PLS-00103: Encountered the symbol "end-of-file" when expecting

One of the following:

Begin end function pragma procedure

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 procedure delete_tab (vtab varchar2)

11 is

12 begin

13 execute immediate 'delete' | | vtab

14 end

15 * end

16 /

Warning: Package Body created with compilation errors.

SQL > show error

Errors for PACKAGE BODY DBMS_PACK1:

LINE/COL ERROR

7/6 PL/SQL: SQL Statement ignored

7/32 PL/SQL: ORA-00942: table or view does not exist

SQL >

SQL > l

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from emp where empno=7788

8 return vsal

9 end

10 procedure delete_tab (vtab varchar2)

11 is

12 begin

13 execute immediate 'delete' | | vtab

14 end

15 * end

SQL > ed

Wrote file afiedt.buf

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from scott.emp where empno=7788

8 return vsal

9 end

10 procedure delete_tab (vtab varchar2)

11 is

12 begin

13 execute immediate 'delete' | | vtab

14 end

15 * end

SQL > /

Package body created.

SQL > l

1 create or replace package body dbms_pack1

2 is

3 function gte_sal return number

4 as

5 vsal number

6 begin

7 select sal into vsal from scott.emp where empno=7788

8 return vsal

9 end

10 procedure delete_tab (vtab varchar2)

11 is

12 begin

13 execute immediate 'delete' | | vtab

14 end

15 * end

SQL >-- instructions for calling the correspondence and procedure of the package

SQL > select text from user_source where name='DBMS_PACK1' AND type='PACKAGE'

2 /

TEXT

Package dbms_pack1

Function gte_sal return number

Procedure delete_tab (vtab varchar2)

End

SQL > select text from user_source where name='DBMS_PACK1' AND type='PACKAGE BODY'

2 /

TEXT

Package body dbms_pack1

Function gte_sal return number

Vsal number

Begin

Select sal into vsal from scott.emp where empno=7788

Return vsal

End

Procedure delete_tab (vtab varchar2)

TEXT

Begin

Execute immediate 'delete' | | vtab

End

15 rows selected.

SQL >-- the caller uses the package

SQL > select text from user_source where name='DBMS_PACK1' AND type='PACKAGE BODY'

2 /

TEXT

Package body dbms_pack1

Function gte_sal return number

Vsal number

Begin

Select sal into vsal from scott.emp where empno=7788

Return vsal

End

Procedure delete_tab (vtab varchar2)

TEXT

Begin

Execute immediate 'delete' | | vtab

End

15 rows selected.

SQL >-- View the data of the packet

SQL > select text from dba_source where name='DBMS_METHDATA'

2 /

No rows selected

SQL > desc dbms_pack1

PROCEDURE DELETE_TAB

Argument Name Type In/Out Default?

VTAB VARCHAR2 IN

FUNCTION GTE_SAL RETURNS NUMBER

SQL > show user

USER is "SYS"

SQL > desc standard

FUNCTION SYS$DSINTERVALSUBTRACT RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

LEFT TIMESTAMP IN

RIGHT TIMESTAMP IN

FUNCTION SYS$DSINTERVALSUBTRACT RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH TIME ZONE IN

RIGHT TIMESTAMP WITH TIME ZONE IN

FUNCTION SYS$DSINTERVALSUBTRACT RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

LEFT TIME IN

RIGHT TIME IN

FUNCTION SYS$DSINTERVALSUBTRACT RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

LEFT TIME WITH TIME ZONE IN

RIGHT TIME WITH TIME ZONE IN

FUNCTION SYS$DSINTERVALSUBTRACT RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT DATE IN

FUNCTION SYS$DSINTERVALSUBTRACT RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH LOCAL TIME ZONE IN

RIGHT TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

T TIME IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

T TIME WITH TIME ZONE IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

T TIMESTAMP IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

T TIMESTAMP WITH TIME ZONE IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

T TIMESTAMP WITH LOCAL TIME ZONE IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

T DATE IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

I INTERVAL YEAR TO MONTH IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_FROM RETURNS NUMBER

Argument Name Type In/Out Default?

I INTERVAL DAY TO SECOND IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_STRING_FROM RETURNS VARCHAR2

Argument Name Type In/Out Default?

T TIME WITH TIME ZONE IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_STRING_FROM RETURNS VARCHAR2

Argument Name Type In/Out Default?

T TIMESTAMP WITH TIME ZONE IN

FIELD VARCHAR2 IN

FUNCTION SYS$EXTRACT_STRING_FROM RETURNS VARCHAR2

Argument Name Type In/Out Default?

T TIMESTAMP WITH LOCAL TIME ZONE IN

FIELD VARCHAR2 IN

FUNCTION SYS$STANDARD_CHR RETURNS VARCHAR2

Argument Name Type In/Out Default?

N BINARY_INTEGER IN

CSN VARCHAR2 IN

FUNCTION SYS$STANDARD_TRANSLATE RETURNS VARCHAR2

Argument Name Type In/Out Default?

SRC VARCHAR2 IN

CSN VARCHAR2 IN

FUNCTION SYS$STANDARD_TRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

V VARCHAR2 IN

FUNCTION SYS$STANDARD_TRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

TRFLAG BINARY_INTEGER IN

FUNCTION SYS$STANDARD_TRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

TSET VARCHAR2 IN

TRFLAG BINARY_INTEGER IN

FUNCTION SYS$STANDARD_TRIM RETURNS CLOB

Argument Name Type In/Out Default?

V CLOB IN

FUNCTION SYS$STANDARD_TRIM RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

TRFLAG BINARY_INTEGER IN

FUNCTION SYS$STANDARD_TRIM RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

TSET CLOB IN

TRFLAG BINARY_INTEGER IN

FUNCTION SYS$YMINTERVALSUBTRACT RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

LEFT TIMESTAMP IN

RIGHT TIMESTAMP IN

FUNCTION SYS$YMINTERVALSUBTRACT RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH TIME ZONE IN

RIGHT TIMESTAMP WITH TIME ZONE IN

FUNCTION SYS$YMINTERVALSUBTRACT RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT DATE IN

FUNCTION SYS$YMINTERVALSUBTRACT RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH LOCAL TIME ZONE IN

RIGHT TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION ABS RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION ABS RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F BINARY_FLOAT IN

FUNCTION ABS RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION ABS RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

I BINARY_INTEGER IN

FUNCTION ACOS RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION ACOS RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION ADD_MONTHS RETURNS DATE

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT NUMBER IN

FUNCTION ADD_MONTHS RETURNS DATE

Argument Name Type In/Out Default?

LEFT NUMBER IN

RIGHT DATE IN

FUNCTION ASCII RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION ASCIISTR RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION ASIN RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION ASIN RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION ATAN RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION ATAN RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION ATAN2 RETURNS NUMBER

Argument Name Type In/Out Default?

X NUMBER IN

Y NUMBER IN

FUNCTION ATAN2 RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

X BINARY_DOUBLE IN

Y BINARY_DOUBLE IN

FUNCTION BFILENAME RETURNS BINARY FILE LOB

Argument Name Type In/Out Default?

DIRECTORY VARCHAR2 IN

FILENAME VARCHAR2 IN

FUNCTION BITAND RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

LEFT BINARY_INTEGER IN

RIGHT BINARY_INTEGER IN

FUNCTION BITAND RETURNS NUMBER (38)

Argument Name Type In/Out Default?

LEFT NUMBER (38) IN

RIGHT NUMBER (38) IN

FUNCTION CARDINALITY RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

COLLECTION IN

FUNCTION CEIL RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION CEIL RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F BINARY_FLOAT IN

FUNCTION CEIL RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION CHARTOROWID RETURNS ROWID

Argument Name Type In/Out Default?

STR VARCHAR2 IN

FUNCTION CHR RETURNS VARCHAR2

Argument Name Type In/Out Default?

N BINARY_INTEGER IN

FUNCTION COALESCE RETURNS VARCHAR2

PROCEDURE COMMIT

PROCEDURE COMMIT_CM

Argument Name Type In/Out Default?

VC VARCHAR2 IN

FUNCTION COMPOSE RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION CONCAT RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

RIGHT VARCHAR2 IN

FUNCTION CONCAT RETURNS CLOB

Argument Name Type In/Out Default?

LEFT CLOB IN

RIGHT CLOB IN

PROCEDURE CONTINUE

FUNCTION CONVERT RETURNS VARCHAR2

Argument Name Type In/Out Default?

SRC VARCHAR2 IN

DESTCSET VARCHAR2 IN

FUNCTION CONVERT RETURNS VARCHAR2

Argument Name Type In/Out Default?

SRC VARCHAR2 IN

DESTCSET VARCHAR2 IN

SRCCSET VARCHAR2 IN

FUNCTION CONVERT RETURNS CLOB

Argument Name Type In/Out Default?

SRCSTR CLOB IN

DSTCSN VARCHAR2 IN

FUNCTION CONVERT RETURNS CLOB

Argument Name Type In/Out Default?

SRCSTR CLOB IN

DSTCSN VARCHAR2 IN

SRCCSN VARCHAR2 IN

FUNCTION COS RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION COS RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION COSH RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION COSH RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION CUBE RETURNS NUMBER

FUNCTION CURRENT_DATE RETURNS DATE

FUNCTION CURRENT_TIME RETURNS TIME WITH TIME ZONE

FUNCTION CURRENT_TIMESTAMP RETURNS TIMESTAMP WITH TIME ZONE

FUNCTION DBTIMEZONE RETURNS VARCHAR2

FUNCTION DECODE RETURNS NUMBER

Argument Name Type In/Out Default?

EXPR NUMBER IN

PAT NUMBER IN

RES NUMBER IN

FUNCTION DECODE RETURNS VARCHAR2

Argument Name Type In/Out Default?

EXPR NUMBER IN

PAT NUMBER IN

RES VARCHAR2 IN

FUNCTION DECODE RETURNS DATE

Argument Name Type In/Out Default?

EXPR NUMBER IN

PAT NUMBER IN

RES DATE IN

FUNCTION DECODE RETURNS NUMBER

Argument Name Type In/Out Default?

EXPR VARCHAR2 IN

PAT VARCHAR2 IN

RES NUMBER IN

FUNCTION DECODE RETURNS VARCHAR2

Argument Name Type In/Out Default?

EXPR VARCHAR2 IN

PAT VARCHAR2 IN

RES VARCHAR2 IN

FUNCTION DECODE RETURNS DATE

Argument Name Type In/Out Default?

EXPR VARCHAR2 IN

PAT VARCHAR2 IN

RES DATE IN

FUNCTION DECODE RETURNS NUMBER

Argument Name Type In/Out Default?

EXPR DATE IN

PAT DATE IN

RES NUMBER IN

FUNCTION DECODE RETURNS VARCHAR2

Argument Name Type In/Out Default?

EXPR DATE IN

PAT DATE IN

RES VARCHAR2 IN

FUNCTION DECODE RETURNS DATE

Argument Name Type In/Out Default?

EXPR DATE IN

PAT DATE IN

RES DATE IN

FUNCTION DECODE RETURNS

Argument Name Type In/Out Default?

EXPR IN

PAT IN

RES IN

FUNCTION DECODE RETURNS

Argument Name Type In/Out Default?

EXPR IN

PAT IN

RES IN

FUNCTION DECOMPOSE RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

CANMODE VARCHAR2 IN DEFAULT

FUNCTION DEREF RETURNS

Argument Name Type In/Out Default?

R REF OF STANDARD IN

FUNCTION DUMP RETURNS VARCHAR2

Argument Name Type In/Out Default?

E VARCHAR2 IN

DF BINARY_INTEGER IN DEFAULT

SP BINARY_INTEGER IN DEFAULT

LEN BINARY_INTEGER IN DEFAULT

FUNCTION DUMP RETURNS VARCHAR2

Argument Name Type In/Out Default?

E NUMBER IN

DF BINARY_INTEGER IN DEFAULT

SP BINARY_INTEGER IN DEFAULT

LEN BINARY_INTEGER IN DEFAULT

FUNCTION DUMP RETURNS VARCHAR2

Argument Name Type In/Out Default?

E DATE IN

DF BINARY_INTEGER IN DEFAULT

SP BINARY_INTEGER IN DEFAULT

LEN BINARY_INTEGER IN DEFAULT

FUNCTION EMPTY_BLOB RETURNS BLOB

FUNCTION EMPTY_CLOB RETURNS CLOB

FUNCTION EXISTS RETURNS BOOLEAN

FUNCTION EXP RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION EXP RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION FLOOR RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION FLOOR RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F BINARY_FLOAT IN

FUNCTION FLOOR RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION FROM_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

T TIMESTAMP IN

TIMEZONE VARCHAR2 IN

FUNCTION GLB RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

LABEL RAW MLSLABEL IN

FUNCTION GREATEST RETURNS NUMBER

Argument Name Type In/Out Default?

PATTERN NUMBER IN

FUNCTION GREATEST RETURNS VARCHAR2

Argument Name Type In/Out Default?

PATTERN VARCHAR2 IN

FUNCTION GREATEST RETURNS DATE

Argument Name Type In/Out Default?

PATTERN DATE IN

FUNCTION GREATEST RETURNS TIME

Argument Name Type In/Out Default?

PATTERN TIME IN

FUNCTION GREATEST RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

PATTERN TIME WITH TIME ZONE IN

FUNCTION GREATEST RETURNS TIMESTAMP

Argument Name Type In/Out Default?

PATTERN TIMESTAMP IN

FUNCTION GREATEST RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

PATTERN TIMESTAMP WITH TIME ZONE IN

FUNCTION GREATEST RETURNS TIMESTAMP WITH LOCAL TIME ZONE

Argument Name Type In/Out Default?

PATTERN TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION GREATEST RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

PATTERN INTERVAL YEAR TO MONTH IN

FUNCTION GREATEST RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

PATTERN INTERVAL DAY TO SECOND IN

FUNCTION GREATEST RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

PATTERN BINARY_FLOAT IN

FUNCTION GREATEST RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

PATTERN BINARY_DOUBLE IN

FUNCTION GREATEST RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

PATTERN BINARY_INTEGER IN

FUNCTION GREATEST_LB RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

PATTERN RAW MLSLABEL IN

FUNCTION GROUPING RETURNS NUMBER

Argument Name Type In/Out Default?

V VARCHAR2 IN

FUNCTION GROUPING RETURNS NUMBER

Argument Name Type In/Out Default?

An IN

FUNCTION GROUPING RETURNS NUMBER

Argument Name Type In/Out Default?

An IN

FUNCTION HEXTORAW RETURNS RAW

Argument Name Type In/Out Default?

C VARCHAR2 IN

FUNCTION INITCAP RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION INSTR RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

STR2 VARCHAR2 IN

POS BINARY_INTEGER IN DEFAULT

NTH BINARY_INTEGER IN DEFAULT

FUNCTION INSTR RETURNS NUMBER (38)

Argument Name Type In/Out Default?

STR1 CLOB IN

STR2 CLOB IN

POS NUMBER (38) IN DEFAULT

NTH NUMBER (38) IN DEFAULT

FUNCTION INSTR2 RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

STR2 VARCHAR2 IN

POS BINARY_INTEGER IN DEFAULT

NTH BINARY_INTEGER IN DEFAULT

FUNCTION INSTR4 RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

STR2 VARCHAR2 IN

POS BINARY_INTEGER IN DEFAULT

NTH BINARY_INTEGER IN DEFAULT

FUNCTION INSTRB RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

STR2 VARCHAR2 IN

POS BINARY_INTEGER IN DEFAULT

NTH BINARY_INTEGER IN DEFAULT

FUNCTION INSTRB RETURNS NUMBER (38)

Argument Name Type In/Out Default?

STR1 CLOB IN

STR2 CLOB IN

POS NUMBER (38) IN DEFAULT

NTH NUMBER (38) IN DEFAULT

FUNCTION INSTRC RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

STR2 VARCHAR2 IN

POS BINARY_INTEGER IN DEFAULT

NTH BINARY_INTEGER IN DEFAULT

FUNCTION ISNCHAR RETURNS BOOLEAN

Argument Name Type In/Out Default?

C VARCHAR2 IN

FUNCTION LAST_DAY RETURNS DATE

Argument Name Type In/Out Default?

RIGHT DATE IN

FUNCTION LEAST RETURNS NUMBER

Argument Name Type In/Out Default?

PATTERN NUMBER IN

FUNCTION LEAST RETURNS VARCHAR2

Argument Name Type In/Out Default?

PATTERN VARCHAR2 IN

FUNCTION LEAST RETURNS DATE

Argument Name Type In/Out Default?

PATTERN DATE IN

FUNCTION LEAST RETURNS TIME

Argument Name Type In/Out Default?

PATTERN TIME IN

FUNCTION LEAST RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

PATTERN TIME WITH TIME ZONE IN

FUNCTION LEAST RETURNS TIMESTAMP

Argument Name Type In/Out Default?

PATTERN TIMESTAMP IN

FUNCTION LEAST RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

PATTERN TIMESTAMP WITH TIME ZONE IN

FUNCTION LEAST RETURNS TIMESTAMP WITH LOCAL TIME ZONE

Argument Name Type In/Out Default?

PATTERN TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION LEAST RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

PATTERN INTERVAL YEAR TO MONTH IN

FUNCTION LEAST RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

PATTERN INTERVAL DAY TO SECOND IN

FUNCTION LEAST RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

PATTERN BINARY_FLOAT IN

FUNCTION LEAST RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

PATTERN BINARY_DOUBLE IN

FUNCTION LEAST RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

PATTERN BINARY_INTEGER IN

FUNCTION LEAST_UB RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

PATTERN RAW MLSLABEL IN

FUNCTION LENGTH RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION LENGTH RETURNS NUMBER (38)

Argument Name Type In/Out Default?

CH CLOB IN

FUNCTION LENGTH RETURNS NUMBER (38)

Argument Name Type In/Out Default?

BL BLOB IN

FUNCTION LENGTH2 RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION LENGTH4 RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION LENGTHB RETURNS NUMBER

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION LENGTHB RETURNS NUMBER (38)

Argument Name Type In/Out Default?

CH CLOB IN

FUNCTION LENGTHB RETURNS NUMBER (38)

Argument Name Type In/Out Default?

BL BLOB IN

FUNCTION LENGTHC RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION LEVEL RETURNS NUMBER

FUNCTION LN RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION LN RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION LOCALTIME RETURNS TIME

FUNCTION LOCALTIMESTAMP RETURNS TIMESTAMP

FUNCTION LOG RETURNS NUMBER

Argument Name Type In/Out Default?

LEFT NUMBER IN

RIGHT NUMBER IN

FUNCTION LOG RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

LEFT BINARY_DOUBLE IN

RIGHT BINARY_DOUBLE IN

FUNCTION LOWER RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION LOWER RETURNS CLOB

Argument Name Type In/Out Default?

CH CLOB IN

FUNCTION LPAD RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

LEN BINARY_INTEGER IN

PAD VARCHAR2 IN

FUNCTION LPAD RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

LEN BINARY_INTEGER IN

FUNCTION LPAD RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

LEN NUMBER (38) IN

PAD CLOB IN

FUNCTION LPAD RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

LEN NUMBER (38) IN

FUNCTION LTRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN DEFAULT

TSET VARCHAR2 IN

FUNCTION LTRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN DEFAULT

FUNCTION LTRIM RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

TSET CLOB IN

FUNCTION LTRIM RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

FUNCTION LUB RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

LABEL RAW MLSLABEL IN

FUNCTION MONTHS_BETWEEN RETURNS NUMBER

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT DATE IN

FUNCTION NANVL RETURNS NUMBER

Argument Name Type In/Out Default?

N1 NUMBER IN

N2 NUMBER IN

FUNCTION NANVL RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F1 BINARY_FLOAT IN

F2 BINARY_FLOAT IN

FUNCTION NANVL RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D1 BINARY_DOUBLE IN

D2 BINARY_DOUBLE IN

FUNCTION NCHARTOROWID RETURNS ROWID

Argument Name Type In/Out Default?

STR NVARCHAR2 IN

FUNCTION NCHR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

N BINARY_INTEGER IN

FUNCTION NEW_TIME RETURNS DATE

Argument Name Type In/Out Default?

RIGHT DATE IN

MIDDLE VARCHAR2 IN

LEFT VARCHAR2 IN

FUNCTION NEXT_DAY RETURNS DATE

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT VARCHAR2 IN

FUNCTION NHEXTORAW RETURNS RAW

Argument Name Type In/Out Default?

C NVARCHAR2 IN

FUNCTION NLSSORT RETURNS RAW

Argument Name Type In/Out Default?

C VARCHAR2 IN

FUNCTION NLSSORT RETURNS RAW

Argument Name Type In/Out Default?

C VARCHAR2 IN

C2 VARCHAR2 IN

FUNCTION NLS_CHARSET_DECL_LEN RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

BYTECNT NUMBER IN

CSETID NUMBER IN

FUNCTION NLS_CHARSET_ID RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

CSETNAME VARCHAR2 IN

FUNCTION NLS_CHARSET_NAME RETURNS VARCHAR2

Argument Name Type In/Out Default?

CSETID BINARY_INTEGER IN

FUNCTION NLS_INITCAP RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION NLS_INITCAP RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION NLS_LOWER RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION NLS_LOWER RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION NLS_LOWER RETURNS CLOB

Argument Name Type In/Out Default?

CH CLOB IN

PARMS VARCHAR2 IN

FUNCTION NLS_LOWER RETURNS CLOB

Argument Name Type In/Out Default?

CH CLOB IN

FUNCTION NLS_UPPER RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION NLS_UPPER RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION NLS_UPPER RETURNS CLOB

Argument Name Type In/Out Default?

CH CLOB IN

PARMS VARCHAR2 IN

FUNCTION NLS_UPPER RETURNS CLOB

Argument Name Type In/Out Default?

CH CLOB IN

FUNCTION NULLFN RETURNS RAW

Argument Name Type In/Out Default?

STR VARCHAR2 IN

FUNCTION NULLIF RETURNS VARCHAR2

Argument Name Type In/Out Default?

V1 VARCHAR2 IN

V2 VARCHAR2 IN

FUNCTION NULLIF RETURNS VARCHAR2

Argument Name Type In/Out Default?

V1 BOOLEAN IN

V2 BOOLEAN IN

FUNCTION NULLIF RETURNS VARCHAR2

Argument Name Type In/Out Default?

A1 IN

A2 IN

FUNCTION NULLIF RETURNS VARCHAR2

Argument Name Type In/Out Default?

A1 IN

A2 IN

FUNCTION NUMTODSINTERVAL RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

NUMERATOR NUMBER IN

UNITS VARCHAR2 IN

FUNCTION NUMTOYMINTERVAL RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

NUMERATOR NUMBER IN

UNITS VARCHAR2 IN

FUNCTION NVL RETURNS BOOLEAN

Argument Name Type In/Out Default?

B1 BOOLEAN IN

B2 BOOLEAN IN

FUNCTION NVL RETURNS VARCHAR2

Argument Name Type In/Out Default?

S1 VARCHAR2 IN

S2 VARCHAR2 IN

FUNCTION NVL RETURNS NUMBER

Argument Name Type In/Out Default?

N1 NUMBER IN

N2 NUMBER IN

FUNCTION NVL RETURNS DATE

Argument Name Type In/Out Default?

D1 DATE IN

D2 DATE IN

FUNCTION NVL RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

LABEL1 RAW MLSLABEL IN

LABEL2 RAW MLSLABEL IN

FUNCTION NVL RETURNS

Argument Name Type In/Out Default?

B1 IN

B2 IN

FUNCTION NVL RETURNS REF OF STANDARD

Argument Name Type In/Out Default?

B1 REF OF STANDARD IN

B2 REF OF STANDARD IN

FUNCTION NVL RETURNS

Argument Name Type In/Out Default?

B1 IN

B2 IN

FUNCTION NVL RETURNS REF CURSOR

Argument Name Type In/Out Default?

B1 REF CURSOR IN

B2 REF CURSOR IN

FUNCTION NVL RETURNS TIME

Argument Name Type In/Out Default?

B1 TIME IN

B2 TIME IN

FUNCTION NVL RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

B1 TIME WITH TIME ZONE IN

B2 TIME WITH TIME ZONE IN

FUNCTION NVL RETURNS TIMESTAMP

Argument Name Type In/Out Default?

B1 TIMESTAMP IN

B2 TIMESTAMP IN

FUNCTION NVL RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

B1 TIMESTAMP WITH TIME ZONE IN

B2 TIMESTAMP WITH TIME ZONE IN

FUNCTION NVL RETURNS TIMESTAMP WITH LOCAL TIME ZONE

Argument Name Type In/Out Default?

B1 TIMESTAMP WITH LOCAL TIME ZONE IN

B2 TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION NVL RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

B1 INTERVAL YEAR TO MONTH IN

B2 INTERVAL YEAR TO MONTH IN

FUNCTION NVL RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

B1 INTERVAL DAY TO SECOND IN

B2 INTERVAL DAY TO SECOND IN

FUNCTION NVL RETURNS CLOB

Argument Name Type In/Out Default?

S1 CLOB IN

S2 CLOB IN

FUNCTION NVL RETURNS

Argument Name Type In/Out Default?

B1 IN

B2 IN

FUNCTION NVL RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F1 BINARY_FLOAT IN

F2 BINARY_FLOAT IN

FUNCTION NVL RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D1 BINARY_DOUBLE IN

D2 BINARY_DOUBLE IN

FUNCTION NVL RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

I1 BINARY_INTEGER IN

I2 BINARY_INTEGER IN

FUNCTION POWER RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

E NUMBER IN

FUNCTION POWER RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

E BINARY_DOUBLE IN

FUNCTION RAWTOHEX RETURNS VARCHAR2

Argument Name Type In/Out Default?

R RAW IN

FUNCTION RAWTONHEX RETURNS NVARCHAR2

Argument Name Type In/Out Default?

R RAW IN

FUNCTION REF RETURNS REF OF STANDARD

Argument Name Type In/Out Default?

ITEM IN

FUNCTION REGEXP_COUNT RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

SRCSTR VARCHAR2 IN

PATTERN VARCHAR2 IN

POSITION BINARY_INTEGER IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_COUNT RETURNS NUMBER (38)

Argument Name Type In/Out Default?

SRCSTR CLOB IN

PATTERN VARCHAR2 IN

POSITION NUMBER (38) IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_INSTR RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

SRCSTR VARCHAR2 IN

PATTERN VARCHAR2 IN

POSITION BINARY_INTEGER IN DEFAULT

OCCURRENCE BINARY_INTEGER IN DEFAULT

RETURNPARAM BINARY_INTEGER IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

SUBEXPRESSION BINARY_INTEGER IN DEFAULT

FUNCTION REGEXP_INSTR RETURNS NUMBER (38)

Argument Name Type In/Out Default?

SRCSTR CLOB IN

PATTERN VARCHAR2 IN

POSITION NUMBER (38) IN DEFAULT

OCCURRENCE NUMBER (38) IN DEFAULT

RETURNPARAM BINARY_INTEGER IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

SUBEXPRESSION BINARY_INTEGER IN DEFAULT

FUNCTION REGEXP_LIKE RETURNS BOOLEAN

Argument Name Type In/Out Default?

SRCSTR VARCHAR2 IN

PATTERN VARCHAR2 IN

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_LIKE RETURNS BOOLEAN

Argument Name Type In/Out Default?

SRCSTR CLOB IN

PATTERN VARCHAR2 IN

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_REPLACE RETURNS VARCHAR2

Argument Name Type In/Out Default?

SRCSTR VARCHAR2 IN

PATTERN VARCHAR2 IN

REPLACESTR VARCHAR2 IN DEFAULT

POSITION BINARY_INTEGER IN DEFAULT

OCCURRENCE BINARY_INTEGER IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_REPLACE RETURNS CLOB

Argument Name Type In/Out Default?

SRCSTR CLOB IN

PATTERN VARCHAR2 IN

REPLACESTR CLOB IN DEFAULT

POSITION NUMBER (38) IN DEFAULT

OCCURRENCE NUMBER (38) IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_REPLACE RETURNS CLOB

Argument Name Type In/Out Default?

SRCSTR CLOB IN

PATTERN VARCHAR2 IN

REPLACESTR VARCHAR2 IN DEFAULT

POSITION NUMBER (38) IN DEFAULT

OCCURRENCE NUMBER (38) IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

FUNCTION REGEXP_SUBSTR RETURNS VARCHAR2

Argument Name Type In/Out Default?

SRCSTR VARCHAR2 IN

PATTERN VARCHAR2 IN

POSITION BINARY_INTEGER IN DEFAULT

OCCURRENCE BINARY_INTEGER IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

SUBEXPRESSION BINARY_INTEGER IN DEFAULT

FUNCTION REGEXP_SUBSTR RETURNS CLOB

Argument Name Type In/Out Default?

SRCSTR CLOB IN

PATTERN VARCHAR2 IN

POSITION NUMBER (38) IN DEFAULT

OCCURRENCE NUMBER (38) IN DEFAULT

MODIFIER VARCHAR2 IN DEFAULT

SUBEXPRESSION BINARY_INTEGER IN DEFAULT

FUNCTION REMAINDER RETURNS NUMBER

Argument Name Type In/Out Default?

N1 NUMBER IN

N2 NUMBER IN

FUNCTION REMAINDER RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F1 BINARY_FLOAT IN

F2 BINARY_FLOAT IN

FUNCTION REMAINDER RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D1 BINARY_DOUBLE IN

D2 BINARY_DOUBLE IN

FUNCTION REPLACE RETURNS VARCHAR2

Argument Name Type In/Out Default?

SRCSTR VARCHAR2 IN

OLDSUB VARCHAR2 IN

NEWSUB VARCHAR2 IN DEFAULT

FUNCTION REPLACE RETURNS CLOB

Argument Name Type In/Out Default?

SRCSTR CLOB IN

OLDSUB CLOB IN

NEWSUB CLOB IN DEFAULT

PROCEDURE ROLLBACK_NR

PROCEDURE ROLLBACK_SV

Argument Name Type In/Out Default?

SAVE_POINT CHAR IN

FUNCTION ROLLUP RETURNS NUMBER

FUNCTION ROUND RETURNS NUMBER

Argument Name Type In/Out Default?

LEFT NUMBER IN

RIGHT BINARY_INTEGER IN DEFAULT

FUNCTION ROUND RETURNS DATE

Argument Name Type In/Out Default?

RIGHT DATE IN

FUNCTION ROUND RETURNS DATE

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT VARCHAR2 IN

FUNCTION ROUND RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

LEFT BINARY_FLOAT IN

FUNCTION ROUND RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

LEFT BINARY_DOUBLE IN

FUNCTION ROUND RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

I BINARY_INTEGER IN

PLACES BINARY_INTEGER IN DEFAULT

FUNCTION ROWID RETURNS ROWID

FUNCTION ROWIDTOCHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR ROWID IN

FUNCTION ROWIDTONCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

STR ROWID IN

FUNCTION ROWLABEL RETURNS RAW MLSLABEL

FUNCTION ROWNUM RETURNS NUMBER

FUNCTION RPAD RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

LEN BINARY_INTEGER IN

PAD VARCHAR2 IN

FUNCTION RPAD RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

LEN BINARY_INTEGER IN

FUNCTION RPAD RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

LEN NUMBER (38) IN

PAD CLOB IN

FUNCTION RPAD RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

LEN NUMBER (38) IN

FUNCTION RTRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN DEFAULT

TSET VARCHAR2 IN

FUNCTION RTRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN DEFAULT

FUNCTION RTRIM RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

TSET CLOB IN

FUNCTION RTRIM RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

PROCEDURE SAVEPOINT

Argument Name Type In/Out Default?

SAVE_POINT CHAR IN

FUNCTION SESSIONTIMEZONE RETURNS VARCHAR2

FUNCTION SET RETURNS

Argument Name Type In/Out Default?

COLLECTION IN

PROCEDURE SET_TRANSACTION_USE

Argument Name Type In/Out Default?

VC VARCHAR2 IN

FUNCTION SIGN RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION SIGN RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

F BINARY_FLOAT IN

FUNCTION SIGN RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION SIGN RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

I BINARY_INTEGER IN

FUNCTION SIN RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION SIN RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION SINH RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION SINH RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION SOUNDEX RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION SQLCODE RETURNS BINARY_INTEGER

FUNCTION SQLERRM RETURNS VARCHAR2

Argument Name Type In/Out Default?

CODE BINARY_INTEGER IN

FUNCTION SQRT RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION SQRT RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F BINARY_FLOAT IN

FUNCTION SQRT RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION SUBSTR RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

POS BINARY_INTEGER IN

LEN BINARY_INTEGER IN DEFAULT

FUNCTION SUBSTR RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

POS NUMBER (38) IN

LEN NUMBER (38) IN DEFAULT

FUNCTION SUBSTR2 RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

POS BINARY_INTEGER IN

LEN BINARY_INTEGER IN DEFAULT

FUNCTION SUBSTR4 RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

POS BINARY_INTEGER IN

LEN BINARY_INTEGER IN DEFAULT

FUNCTION SUBSTRB RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

POS BINARY_INTEGER IN

LEN BINARY_INTEGER IN DEFAULT

FUNCTION SUBSTRB RETURNS CLOB

Argument Name Type In/Out Default?

STR1 CLOB IN

POS NUMBER (38) IN

LEN NUMBER (38) IN DEFAULT

FUNCTION SUBSTRC RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

POS BINARY_INTEGER IN

LEN BINARY_INTEGER IN DEFAULT

FUNCTION SYS$LOB_REPLICATION RETURNS BLOB

Argument Name Type In/Out Default?

X BLOB IN

FUNCTION SYS$LOB_REPLICATION RETURNS CLOB

Argument Name Type In/Out Default?

X CLOB IN

FUNCTION SYSDATE RETURNS DATE

FUNCTION SYSTIMESTAMP RETURNS TIMESTAMP WITH TIME ZONE

FUNCTION SYS_AT_TIME_ZONE RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

T TIME WITH TIME ZONE IN

I VARCHAR2 IN

FUNCTION SYS_AT_TIME_ZONE RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

T TIMESTAMP WITH TIME ZONE IN

I VARCHAR2 IN

FUNCTION SYS_CONTEXT RETURNS VARCHAR2

Argument Name Type In/Out Default?

NAMESPACE VARCHAR2 IN

ATTRIBUTE VARCHAR2 IN

FUNCTION SYS_CONTEXT RETURNS VARCHAR2

Argument Name Type In/Out Default?

NAMESPACE VARCHAR2 IN

ATTRIBUTE VARCHAR2 IN

NEWOPTIONAL VARCHAR2 IN

FUNCTION SYS_EXTRACT_UTC RETURNS TIMESTAMP

Argument Name Type In/Out Default?

T TIMESTAMP WITH TIME ZONE IN

FUNCTION SYS_GUID RETURNS RAW

FUNCTION SYS_LITERALTODATE RETURNS DATE

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

FUNCTION SYS_LITERALTODSINTERVAL RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

UNITS VARCHAR2 IN

FUNCTION SYS_LITERALTOTIME RETURNS TIME

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

FUNCTION SYS_LITERALTOTIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

FUNCTION SYS_LITERALTOTZTIME RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

FUNCTION SYS_LITERALTOTZTIMESTAMP RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

FUNCTION SYS_LITERALTOYMINTERVAL RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

NUMERATOR VARCHAR2 IN

UNITS VARCHAR2 IN

FUNCTION TAN RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION TAN RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION TANH RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

FUNCTION TANH RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION TO_ANYLOB RETURNS CLOB

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_BINARY_DOUBLE RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

RIGHT BINARY_DOUBLE IN

FUNCTION TO_BINARY_DOUBLE RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_BINARY_DOUBLE RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_BINARY_FLOAT RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

RIGHT BINARY_FLOAT IN

FUNCTION TO_BINARY_FLOAT RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_BINARY_FLOAT RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_BLOB RETURNS BLOB

Argument Name Type In/Out Default?

RIGHT RAW IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT NUMBER IN

RIGHT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LABEL RAW MLSLABEL IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT DATE IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT NUMBER IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIME IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIME IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIME WITH TIME ZONE IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIME WITH TIME ZONE IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIMESTAMP IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIMESTAMP IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH TIME ZONE IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH TIME ZONE IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH LOCAL TIME ZONE IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT TIMESTAMP WITH LOCAL TIME ZONE IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT INTERVAL YEAR TO MONTH IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT INTERVAL YEAR TO MONTH IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT INTERVAL DAY TO SECOND IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT INTERVAL DAY TO SECOND IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_FLOAT IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_DOUBLE IN

FORMAT VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_FLOAT IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CHAR RETURNS VARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_DOUBLE IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_CLOB RETURNS CLOB

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_CLOB RETURNS CLOB

Argument Name Type In/Out Default?

CL CLOB IN

FUNCTION TO_DATE RETURNS DATE

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_DATE RETURNS DATE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

RIGHT VARCHAR2 IN

FUNCTION TO_DATE RETURNS DATE

Argument Name Type In/Out Default?

LEFT NUMBER IN

RIGHT VARCHAR2 IN

FUNCTION TO_DATE RETURNS DATE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_DSINTERVAL RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_DSINTERVAL RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_LABEL RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

LABEL VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_LABEL RETURNS RAW MLSLABEL

Argument Name Type In/Out Default?

LABEL VARCHAR2 IN

FUNCTION TO_MULTI_BYTE RETURNS VARCHAR2

Argument Name Type In/Out Default?

C VARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

RIGHT NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT DATE IN

FORMAT NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT NUMBER IN

FORMAT NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT DATE IN

FORMAT NVARCHAR2 IN

PARMS NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT NUMBER IN

FORMAT NVARCHAR2 IN

PARMS NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_FLOAT IN

FORMAT NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_DOUBLE IN

FORMAT NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_FLOAT IN

FORMAT NVARCHAR2 IN

PARMS NVARCHAR2 IN

FUNCTION TO_NCHAR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

LEFT BINARY_DOUBLE IN

FORMAT NVARCHAR2 IN

PARMS NVARCHAR2 IN

FUNCTION TO_NCLOB RETURNS NCLOB

Argument Name Type In/Out Default?

CL CLOB IN

FUNCTION TO_NCLOB RETURNS NCLOB

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_NUMBER RETURNS NUMBER

Argument Name Type In/Out Default?

RIGHT NUMBER IN

FUNCTION TO_NUMBER RETURNS NUMBER

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_NUMBER RETURNS NUMBER

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_NUMBER RETURNS NUMBER

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_RAW RETURNS RAW

Argument Name Type In/Out Default?

RIGHT BLOB IN

FUNCTION TO_SINGLE_BYTE RETURNS VARCHAR2

Argument Name Type In/Out Default?

C VARCHAR2 IN

FUNCTION TO_TIME RETURNS TIME

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_TIME RETURNS TIME

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_TIME RETURNS TIME

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_TIME RETURNS TIME

Argument Name Type In/Out Default?

RIGHT TIME WITH TIME ZONE IN

FUNCTION TO_TIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_TIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_TIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_TIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

RIGHT TIMESTAMP WITH TIME ZONE IN

FUNCTION TO_TIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

RIGHT DATE IN

FUNCTION TO_TIMESTAMP RETURNS TIMESTAMP

Argument Name Type In/Out Default?

ARG TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION TO_TIMESTAMP_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_TIMESTAMP_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_TIMESTAMP_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_TIMESTAMP_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

RIGHT TIMESTAMP IN

FUNCTION TO_TIMESTAMP_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

ARG DATE IN

FUNCTION TO_TIMESTAMP_TZ RETURNS TIMESTAMP WITH TIME ZONE

Argument Name Type In/Out Default?

ARG TIMESTAMP WITH LOCAL TIME ZONE IN

FUNCTION TO_TIME_TZ RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TO_TIME_TZ RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

PARMS VARCHAR2 IN

FUNCTION TO_TIME_TZ RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

LEFT VARCHAR2 IN

FORMAT VARCHAR2 IN

FUNCTION TO_TIME_TZ RETURNS TIME WITH TIME ZONE

Argument Name Type In/Out Default?

RIGHT TIME IN

FUNCTION TO_YMINTERVAL RETURNS INTERVAL YEAR TO MONTH

Argument Name Type In/Out Default?

RIGHT VARCHAR2 IN

FUNCTION TRANSLATE RETURNS VARCHAR2

Argument Name Type In/Out Default?

STR1 VARCHAR2 IN

SRC VARCHAR2 IN

DEST VARCHAR2 IN

FUNCTION TRIM RETURNS VARCHAR2

Argument Name Type In/Out Default?

V VARCHAR2 IN

FUNCTION TRIM RETURNS CLOB

Argument Name Type In/Out Default?

V CLOB IN

FUNCTION TRUNC RETURNS NUMBER

Argument Name Type In/Out Default?

N NUMBER IN

PLACES BINARY_INTEGER IN DEFAULT

FUNCTION TRUNC RETURNS DATE

Argument Name Type In/Out Default?

LEFT DATE IN

FUNCTION TRUNC RETURNS DATE

Argument Name Type In/Out Default?

LEFT DATE IN

RIGHT VARCHAR2 IN

FUNCTION TRUNC RETURNS BINARY_FLOAT

Argument Name Type In/Out Default?

F BINARY_FLOAT IN

FUNCTION TRUNC RETURNS BINARY_DOUBLE

Argument Name Type In/Out Default?

D BINARY_DOUBLE IN

FUNCTION TRUNC RETURNS BINARY_INTEGER

Argument Name Type In/Out Default?

I BINARY_INTEGER IN

PLACES BINARY_INTEGER IN DEFAULT

FUNCTION TZ_OFFSET RETURNS VARCHAR2

Argument Name Type In/Out Default?

REGION VARCHAR2 IN

FUNCTION UID RETURNS BINARY_INTEGER

FUNCTION UNISTR RETURNS NVARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION UPPER RETURNS VARCHAR2

Argument Name Type In/Out Default?

CH VARCHAR2 IN

FUNCTION UPPER RETURNS CLOB

Argument Name Type In/Out Default?

CH CLOB IN

FUNCTION UROWID RETURNS ROWID

FUNCTION USER RETURNS VARCHAR2

FUNCTION USERENV RETURNS VARCHAR2

Argument Name Type In/Out Default?

ENVSTR VARCHAR2 IN

FUNCTION VALUE RETURNS

Argument Name Type In/Out Default?

ITEM IN

FUNCTION VSIZE RETURNS NUMBER

Argument Name Type In/Out Default?

E NUMBER IN

FUNCTION VSIZE RETURNS NUMBER

Argument Name Type In/Out Default?

E DATE IN

FUNCTION VSIZE RETURNS NUMBER

Argument Name Type In/Out Default?

E VARCHAR2 IN

FUNCTION XOR RETURNS BOOLEAN

Argument Name Type In/Out Default?

LEFT BOOLEAN IN

RIGHT BOOLEAN IN

SQL > select dbms_pack1.get_sal from dual

four

SQL > select dbms_pack1.get_sal from dual

2 /

Select dbms_pack1.get_sal from dual

ERROR at line 1:

ORA-00904: "DBMS_PACK1". "GET_SAL": invalid identifier

SQL > select dbms_pack1.egt_sal from dual

2 /

Select dbms_pack1.egt_sal from dual

ERROR at line 1:

ORA-00904: "DBMS_PACK1". "EGT_SAL": invalid identifier

SQL > select dbms_pack1.get_sal from dual

Select dbms_pack1.get_sal from dual

ERROR at line 1:

ORA-00904: "DBMS_PACK1". "GET_SAL": invalid identifier

SQL > select dbms_pack1.tge_sal from dual

Select dbms_pack1.tge_sal from dual

ERROR at line 1:

ORA-00904: "DBMS_PACK1". "TGE_SAL": invalid identifier

SQL >-- determine whether it is the corresponding printout

SQL > exec dbms_out.put_line ('aa')

BEGIN dbms_out.put_line ('aa'); END

ERROR at line 1:

ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_OUT.PUT_LINE' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL > /

Select dbms_pack1.tge_sal from dual

ERROR at line 1:

ORA-00904: "DBMS_PACK1". "TGE_SAL": invalid identifier

SQL > exec dbms_out.put_line (sal,ename)

BEGIN dbms_out.put_line (sal,ename); END

ERROR at line 1:

ORA-06550: line 1, column 25:

PLS-00201: identifier 'SAL' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL > exec dbms_out.put_line (sal,ename)

BEGIN dbms_out.put_line (sal,ename); END

ERROR at line 1:

ORA-06550: line 1, column 25:

PLS-00201: identifier 'SAL' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL > exec dbms_out.put_line (scott.sal,scott.ename)

BEGIN dbms_out.put_line (scott.sal,scott.ename); END

ERROR at line 1:

ORA-06550: line 1, column 25:

PLS-00201: identifier 'SCOTT.SAL' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL > exec dbms_out.put_line (scott.sal,scott.ename)

BEGIN dbms_out.put_line (scott.sal,scott.ename); END

ERROR at line 1:

ORA-06550: line 1, column 25:

PLS-00201: identifier 'SCOTT.SAL' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL > /

Select dbms_pack1.tge_sal from dual

ERROR at line 1:

ORA-00904: "DBMS_PACK1". "TGE_SAL": invalid identifier

SQL >-- roeid

SQL >-- rowid

SQL > create table T5 as select * from emp

Create table T5 as select * from emp

ERROR at line 1:

ORA-00942: table or view does not exist

SQL > create table T5 as select * from scott.emp

Table created.

SQL > insert into T5 select * from T5

2 /

15 rows created.

SQL > insert into T5 select * from T5

2 /

30 rows created.

SQL > insert into T5 select * from T5

2 /

60 rows created.

SQL > insert into T5 select * from T5

2 /

Insert into T5 select * from T5

ERROR at line 1:

ORA-00942: table or view does not exist

SQL > insert into T5 select * from T5

2 /

120 rows created.

SQL > insert into T5 select * from T5

2 /

240 rows created.

SQL > insert into T5 select * from T5

2 /

480 rows created.

SQL > /

960 rows created.

SQL > /

1920 rows created.

SQL > /

3840 rows created.

SQL > /

7680 rows created.

SQL > /

15360 rows created.

SQL > /

30720 rows created.

SQL > /

61440 rows created.

SQL > /

122880 rows created.

SQL > select dbms_rowid.rowid_block_number (rowid), ename from scott.emp

2 /

DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) ENAME

151 SMITH

151 ALLEN

151 WARD

151 JONES

151 MARTIN

151 BLAKE

151 CLARK

151 nihao

151 KING

151 TURNER

151 ADAMS

DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) ENAME

151 JAMES

151 FORD

151 MILLER

one hundred and fifty one

15 rows selected.

SQL > select dbms_rowid.rowid_block_number (rowid), ename from scott.emp

2 /

DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) ENAME

151 SMITH

151 ALLEN

151 WARD

151 JONES

151 MARTIN

151 BLAKE

151 CLARK

151 nihao

151 KING

151 TURNER

151 ADAMS

DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) ENAME

151 JAMES

151 FORD

151 MILLER

one hundred and fifty one

15 rows selected.

SQL > select dbms_rowid.rowid_block_number (rowid), dbms_rowid from scott.emp

2 /

Select dbms_rowid.rowid_block_number (rowid), dbms_rowid from scott.emp

ERROR at line 1:

ORA-06553: PLS-221: 'DBMS_ROWID' is not a procedure or is undefined

SQL > desc dbms_store

ERROR:

ORA-04043: object dbms_store does not exist

SQL > desc dbms_space

FUNCTION ASA_RECOMMENDATIONS RETURNS ASA_RECO_ROW_TB

Argument Name Type In/Out Default?

ALL_RUNS VARCHAR2 IN DEFAULT

SHOW_MANUAL VARCHAR2 IN DEFAULT

SHOW_FINDINGS VARCHAR2 IN DEFAULT

PROCEDURE AUTO_SPACE_ADVISOR_JOB_PROC

PROCEDURE CREATE_INDEX_COST

Argument Name Type In/Out Default?

DDL VARCHAR2 IN

USED_BYTES NUMBER OUT

ALLOC_BYTES NUMBER OUT

PLAN_TABLE VARCHAR2 IN DEFAULT

PROCEDURE CREATE_TABLE_COST

Argument Name Type In/Out Default?

TABLESPACE_NAME VARCHAR2 IN

AVG_ROW_SIZE NUMBER IN

ROW_COUNT NUMBER IN

PCT_FREE NUMBER IN

USED_BYTES NUMBER OUT

ALLOC_BYTES NUMBER OUT

PROCEDURE CREATE_TABLE_COST

Argument Name Type In/Out Default?

TABLESPACE_NAME VARCHAR2 IN

COLINFOS CREATE_TABLE_COST_COLUMNS IN

ROW_COUNT NUMBER IN

PCT_FREE NUMBER IN

USED_BYTES NUMBER OUT

ALLOC_BYTES NUMBER OUT

FUNCTION DBFS_DF RETURNS NUMBER

Argument Name Type In/Out Default?

USERID NUMBER IN

NTBS NUMBER IN

INTS_LIST TABLESPACE_LIST IN

PROCEDURE FREE_BLOCKS

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

FREELIST_GROUP_ID NUMBER IN

FREE_BLKS NUMBER OUT

SCAN_LIMIT NUMBER IN DEFAULT

PARTITION_NAME VARCHAR2 IN DEFAULT

PROCEDURE ISDATAFILEDROPPABLE_NAME

Argument Name Type In/Out Default?

FILENAME VARCHAR2 IN

VALUE NUMBER OUT

FUNCTION OBJECT_DEPENDENT_SEGMENTS RETURNS DEPENDENT_SEGMENTS_TABLE

Argument Name Type In/Out Default?

OBJOWNER VARCHAR2 IN

OBJNAME VARCHAR2 IN

PARTNAME VARCHAR2 IN

OBJTYPE NUMBER IN

FUNCTION OBJECT_GROWTH_TREND RETURNS OBJECT_GROWTH_TREND_TABLE

Argument Name Type In/Out Default?

OBJECT_OWNER VARCHAR2 IN

OBJECT_NAME VARCHAR2 IN

OBJECT_TYPE VARCHAR2 IN

PARTITION_NAME VARCHAR2 IN DEFAULT

START_TIME TIMESTAMP IN DEFAULT

END_TIME TIMESTAMP IN DEFAULT

INTERVAL INTERVAL DAY TO SECOND IN DEFAULT

SKIP_INTERPOLATED VARCHAR2 IN DEFAULT

TIMEOUT_SECONDS NUMBER IN DEFAULT

SINGLE_DATAPOINT_FLAG VARCHAR2 IN DEFAULT

FUNCTION OBJECT_GROWTH_TREND_CUR RETURNS REF CURSOR

Argument Name Type In/Out Default?

OBJECT_OWNER VARCHAR2 IN

OBJECT_NAME VARCHAR2 IN

OBJECT_TYPE VARCHAR2 IN

PARTITION_NAME VARCHAR2 IN DEFAULT

START_TIME TIMESTAMP IN DEFAULT

END_TIME TIMESTAMP IN DEFAULT

INTERVAL INTERVAL DAY TO SECOND IN DEFAULT

SKIP_INTERPOLATED VARCHAR2 IN DEFAULT

TIMEOUT_SECONDS NUMBER IN DEFAULT

FUNCTION OBJECT_GROWTH_TREND_CURTAB RETURNS OBJECT_GROWTH_TREND_TABLE

FUNCTION OBJECT_GROWTH_TREND_I_TO_S RETURNS NUMBER

Argument Name Type In/Out Default?

INTERV INTERVAL DAY TO SECOND IN

FUNCTION OBJECT_GROWTH_TREND_SWRF RETURNS OBJECT_GROWTH_SWRF_TABLE

Argument Name Type In/Out Default?

OBJECT_OWNER VARCHAR2 IN

OBJECT_NAME VARCHAR2 IN

OBJECT_TYPE VARCHAR2 IN

PARTITION_NAME VARCHAR2 IN DEFAULT

FUNCTION OBJECT_GROWTH_TREND_S_TO_I RETURNS INTERVAL DAY TO SECOND

Argument Name Type In/Out Default?

SECSIN NUMBER IN

PROCEDURE OBJECT_SPACE_USAGE

Argument Name Type In/Out Default?

OBJECT_OWNER VARCHAR2 IN

OBJECT_NAME VARCHAR2 IN

OBJECT_TYPE VARCHAR2 IN

SAMPLE_CONTROL NUMBER IN

SPACE_USED NUMBER OUT

SPACE_ALLOCATED NUMBER OUT

CHAIN_PCENT NUMBER OUT

PARTITION_NAME VARCHAR2 IN DEFAULT

PRESERVE_RESULT BOOLEAN IN DEFAULT

TIMEOUT_SECONDS NUMBER IN DEFAULT

FUNCTION OBJECT_SPACE_USAGE_TBF RETURNS OBJECT_SPACE_USAGE_TABLE

Argument Name Type In/Out Default?

OBJECT_OWNER VARCHAR2 IN

OBJECT_NAME VARCHAR2 IN

OBJECT_TYPE VARCHAR2 IN

SAMPLE_CONTROL NUMBER IN

PARTITION_NAME VARCHAR2 IN DEFAULT

PRESERVE_RESULT VARCHAR2 IN DEFAULT

TIMEOUT_SECONDS NUMBER IN DEFAULT

PROCEDURE PARSE_SPACE_ADV_INFO

Argument Name Type In/Out Default?

INFO VARCHAR2 IN

USED_SPACE VARCHAR2 OUT

ALLOCATED_SPACE VARCHAR2 OUT

RECLAIMABLE_SPACE VARCHAR2 OUT

PROCEDURE SPACE_USAGE

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

UNFORMATTED_BLOCKS NUMBER OUT

UNFORMATTED_BYTES NUMBER OUT

FS1_BLOCKS NUMBER OUT

FS1_BYTES NUMBER OUT

FS2_BLOCKS NUMBER OUT

FS2_BYTES NUMBER OUT

FS3_BLOCKS NUMBER OUT

FS3_BYTES NUMBER OUT

FS4_BLOCKS NUMBER OUT

FS4_BYTES NUMBER OUT

FULL_BLOCKS NUMBER OUT

FULL_BYTES NUMBER OUT

PARTITION_NAME VARCHAR2 IN DEFAULT

PROCEDURE SPACE_USAGE

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

SEGMENT_SIZE_BLOCKS NUMBER OUT

SEGMENT_SIZE_BYTES NUMBER OUT

USED_BLOCKS NUMBER OUT

USED_BYTES NUMBER OUT

EXPIRED_BLOCKS NUMBER OUT

EXPIRED_BYTES NUMBER OUT

UNEXPIRED_BLOCKS NUMBER OUT

UNEXPIRED_BYTES NUMBER OUT

PARTITION_NAME VARCHAR2 IN DEFAULT

PROCEDURE SPACE_USAGE

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

SUOPTION NUMBER IN

SEGMENT_SIZE_BLOCKS NUMBER OUT

SEGMENT_SIZE_BYTES NUMBER OUT

USED_BLOCKS NUMBER OUT

USED_BYTES NUMBER OUT

EXPIRED_BLOCKS NUMBER OUT

EXPIRED_BYTES NUMBER OUT

UNEXPIRED_BLOCKS NUMBER OUT

UNEXPIRED_BYTES NUMBER OUT

PARTITION_NAME VARCHAR2 IN DEFAULT

PROCEDURE UNUSED_SPACE

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

TOTAL_BLOCKS NUMBER OUT

TOTAL_BYTES NUMBER OUT

UNUSED_BLOCKS NUMBER OUT

UNUSED_BYTES NUMBER OUT

LAST_USED_EXTENT_FILE_ID NUMBER OUT

LAST_USED_EXTENT_BLOCK_ID NUMBER OUT

LAST_USED_BLOCK NUMBER OUT

PARTITION_NAME VARCHAR2 IN DEFAULT

FUNCTION VERIFY_SHRINK_CANDIDATE RETURNS BOOLEAN

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

SHRINK_TARGET_BYTES NUMBER IN

PARTITION_NAME VARCHAR2 IN DEFAULT

FUNCTION VERIFY_SHRINK_CANDIDATE_TBF RETURNS VERIFY_SHRINK_TABLE

Argument Name Type In/Out Default?

SEGMENT_OWNER VARCHAR2 IN

SEGMENT_NAME VARCHAR2 IN

SEGMENT_TYPE VARCHAR2 IN

SHRINK_TARGET_BYTES NUMBER IN

PARTITION_NAME VARCHAR2 IN DEFAULT

SQL > select name from dba_source where name='DBMS_ROWID'

2 /

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

NAME

DBMS_ROWID

232 rows selected.

SQL >-how do I add something to my bag?

SQL >-encryption operation of the packet

SQL >

SQL > select text from user_source where name='DBMS_PACK1'

2 /

No rows selected

SQL > select text from user_source where name='DBMS_PACK1'

2 /

TEXT

Package dbms_pack1

Function gte_sal return number

Procedure delete_tab (vtab varchar2)

End

Package body dbms_pack1

Function gte_sal return number

Vsal number

Begin

TEXT

Select sal into vsal from scott.emp where empno=7788

Return vsal

End

Procedure delete_tab (vtab varchar2)

Begin

Execute immediate 'delete' | | vtab

End

20 rows selected.

SQL > touch p1.sql

SP2-0734: unknown command beginning "touch p1.s..."-rest of line ignored.

SQL >-- touch 1.sql

SQL >-- 2.copy

SQL >-- 3.warp

SQL > show user

USER is "SYS"

SQL > conn scott/tiger'

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL > conn scott/tiger

Connected.

SQL > @ p1.plb

SP2-0734: unknown command beginning "package bo..."-rest of line ignored.

SP2-0042: unknown command "is"-rest of line ignored.

SP2-0734: unknown command beginning "function g..."-rest of line ignored.

SP2-0042: unknown command "as"-rest of line ignored.

SP2-0044: For a list of known commands enter HELP

And to leave enter EXIT.

SP2-0734: unknown command beginning "vsalnumbe..."-rest of line ignored.

12 @ p1.plb

28 @ p1.plb

44 @ p1.plb

60 /

Procedure delete_tab (vtab varchar2)

ERROR at line 6:

ORA-06550: line 6, column 1:

PLS-00103: Encountered the symbol "PROCEDURE"

ORA-06550: line 12, column 1:

PLS-00103: Encountered the symbol "PACKAGE" when expecting one of the

Following:

Begin function pragma procedure

SQL > exit

At this point, I believe you have a deeper understanding of "the use of the _ plsql function in mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.