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
编辑推荐：
相关推荐
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效
2 月 9 日消息，雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用
2 月 10 日消息，制造商 Musnap 现已在海外推出一款 Oce
