iteye_18341的博客

/*打印Hello Worldcreate [or replace] PROCEDURE 过程名(参数列表) AS PLSQL子程序体；调用存储过程:1. exec sayHelloWorld();2. begin sayHelloWorld(); sayHelloWorld(); end; /*/c...

/*给指定的员工涨100的工资，并打印涨前和涨后的薪水create [or replace] PROCEDURE 过程名(参数列表) AS PLSQL子程序体； SQL> begin 2 raiseSalary(7839); 3 raiseSalary(7566); 4 commit; 5 ...

/*查询某个员工的姓名 月薪 职位*/create or replace procedure queryEmpInfo(eno in number, pename out varchar2, psal out n...

查询某个部门中所有员工的所有信息CREATE OR REPLACE PACKAGE MYPACKAGE AS type empcursor is ref cursor; procedure queryEmpList(dno in number,empList out empcursor);END MYPACKAGE;==================...

create or replace procedure PRC_MAIL_FULL_DLV_SAMPLE IS reportStatDate varchar(8); sqlText varchar(2000); v_etl_temp_time date; cursor p_cursor is select sa.mail_num, ...