0710_plsql 函式
SQL> --包的封裝
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> --建立包體
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/3 PLS-00103: Encountered the symbol "AS" when expecting one of the
following:
begin end function pragma procedure subtype type
<an identifier> <a double-quoted delimited-identifier>
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/10 PLS-00323: subprogram or cursor 'GTE_SAL' is declared in a
package specification and must be defined in the package body
4/11 PLS-00323: 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/11 PLS-00323: 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> --呼叫包體的函授和過程的說明
SQL> select text from user_source where name='DBMS_PACK1' AND type='PACKAGE'
2 /
TEXT
--------------------------------------------------------------------------------
package dbms_pack1
is
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
is
function gte_sal return number
as
vsal number;
begin
select sal into vsal from scott.emp where empno=7788;
return vsal;
end;
procedure delete_tab(vtab varchar2)
is
TEXT
--------------------------------------------------------------------------------
begin
execute immediate 'delete '|| vtab ;
end;
end;
15 rows selected.
SQL> --呼叫者使用包體
SQL> select text from user_source where name='DBMS_PACK1' AND type='PACKAGE BODY'
2 /
TEXT
--------------------------------------------------------------------------------
package body dbms_pack1
is
function gte_sal return number
as
vsal number;
begin
select sal into vsal from scott.emp where empno=7788;
return vsal;
end;
procedure delete_tab(vtab varchar2)
is
TEXT
--------------------------------------------------------------------------------
begin
execute immediate 'delete '|| vtab ;
end;
end;
15 rows selected.
SQL> --檢視包體的資料
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 <TABLE_1> 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 <ADT_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EXPR <ADT_1> IN
PAT <ADT_1> IN
RES <ADT_1> IN
FUNCTION DECODE RETURNS <OPAQUE_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EXPR <OPAQUE_1> IN
PAT <OPAQUE_1> IN
RES <OPAQUE_1> IN
FUNCTION DECOMPOSE RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CH VARCHAR2 IN
CANMODE VARCHAR2 IN DEFAULT
FUNCTION DEREF RETURNS <ADT_1>
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?
------------------------------ ----------------------- ------ --------
A <ADT_1> IN
FUNCTION GROUPING RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
A <OPAQUE_1> 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 <ADT_1> IN
A2 <ADT_1> IN
FUNCTION NULLIF RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
A1 <OPAQUE_1> IN
A2 <OPAQUE_1> 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 <ADT_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
B1 <ADT_1> IN
B2 <ADT_1> 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 <COLLECTION_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
B1 <COLLECTION_1> IN
B2 <COLLECTION_1> 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 <OPAQUE_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
B1 <OPAQUE_1> IN
B2 <OPAQUE_1> 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 <TYPED_TABLE> 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 <TABLE_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COLLECTION <TABLE_1> 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
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 <ADT_1>
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ITEM <TYPED_TABLE> 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
2 .
SQL> select dbms_pack1.get_sal from dual
2 ?
3 ?
4
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> --判斷是不是對應的列印輸出
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
151
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
151
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
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
DBMS_ROWID
NAME
------------------------------
DBMS_ROWID
232 rows selected.
SQL> ---怎麼向包里加東西呢？
SQL> ---包體的加密操作
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
is
function gte_sal return number;
procedure delete_tab(vtab varchar2);
end;
package body dbms_pack1
is
function gte_sal return number
as
vsal number;
begin
TEXT
--------------------------------------------------------------------------------
select sal into vsal from scott.emp where empno=7788;
return vsal;
end;
procedure delete_tab(vtab varchar2)
is
begin
execute immediate 'delete '|| vtab ;
end;
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 "vsal numbe..." - 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
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/69949806/viewspace-2663397/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MySQL函式大全(字串函式，數學函式，日期函式，系統級函式，聚合函式)MySql函式字串
- python中id()函式、zip()函式、map()函式、lamda函式Python函式
- Python 擴充之特殊函式（lambda 函式，map 函式，filter 函式，reduce 函式）Python函式Filter
- 第7章 IF函式 COUNTIF函式 SUMIF函式函式
- MySQL（四）日期函式 NULL函式 字串函式MySql函式Null字串
- (譯) 函式式 JS #2: 函式!函式JS
- 核函式 多項式核函式 高斯核函式(常用)函式
- 第 8 節：函式-匿名函式、遞迴函式函式遞迴
- lambda匿名函式sorted排序函式filter過濾函式map對映函式函式排序Filter
- main函式的入口函式AI函式
- SQL-函式 - 聚合函式SQL函式
- 【每日函式】每日函式（2021.08.16）函式
- 【每日函式】每日函式（2021.08.10）函式
- 【每日函式】每日函式（2021.08.05）函式
- 【每日函式】每日函式（2021.08.06）函式
- 【每日函式】每日函式（2021.08.14）函式
- 【每日函式】每日函式（2021.08.08）函式
- 【每日函式】每日函式（2021.08.09）函式
- 【知識點】inline函式、回撥函式、普通函式inline函式
- Python函式與lambda 表示式（匿名函式）Python函式
- webgl內建函式--幾何函式與矩陣函式Web函式矩陣
- webgl內建函式--向量函式與紋理查詢函式Web函式
- Oracle OCP(03)：字元函式、數字函式和日期函式Oracle字元函式
- 深入理解 函式、匿名函式、自執行匿名函式函式
- 箭頭函式、簡寫函式、普通函式的區別函式
- Hive函式（內建函式+自定義標準函式UDF）Hive函式
- webgl內建函式--通用函式Web函式
- Kotlin之“with”函式和“apply”函式Kotlin函式APP
- Kotlin 函式6 - 高階函式Kotlin函式
- Mysql 常用函式（20）- ceiling 函式MySql函式
- Mysql 常用函式（15）- upper 函式MySql函式
- 探索MySQL高階語句（數學函式、聚合函式、字串函式、日期時間函式）MySql函式字串
- 函式式元件函式元件
- 函式式介面函式
- Python技法3：匿名函式、回撥函式和高階函式Python函式
- python內建函式-eval()函式與exec()函式的區別Python函式
- JavaScript函式宣告和函式表示式區別JavaScript函式
- JS函式表示式——函式遞迴、閉包JS函式遞迴