游标sql语句

系统 1885 0
    declare

cursor emp_cursor (pno in number default 7369)

is select * from emp where empno=pno;



emp_row emp%rowtype;

begin

      open emp_cursor(7934);

      fetch emp_cursor into emp_row;

      dbms_output.put_line(emp_row.ename);



      close emp_cursor;

end;

/







declare

cursor emp_cursor (pno in number default 7369)

is select * from emp where empno=pno;



begin

  for emp_row in emp_cursor(7934) loop

   dbms_output.put_line(emp_row.ename);

  end loop;

end;

/









declare



type emp_cname is ref cursor return emp%rowtype;



ecname emp_cname;



emp_row emp%rowtype;



begin

    dbms_output.put_line('开始');

    open ecname for select * from emp;

    loop

     fetch ecname into emp_row;

     exit when ecname%notfound;

     dbms_output.put_line(emp_row.ename);

    end loop;

    close ecname;

  dbms_output.put_line('结束');

end;

/



//向emp表中添加一条记录

create procedure insert_emp as

begin

  insert into emp(empno,ename,job,mgr,sal,comm,deptno)

  values('7777','redarmy','teacher','7369',9000,1000,20);

  commit;

end insert_emp;





set serveroutput on;

begin

   insert_emp;

end;





create or replace procedure insert_emp as

begin

  insert into emp(empno,ename,job,mgr,sal,comm,deptno)

  values('7777','redarmy','teacher','7369',9000,1000,20);

  commit;

end insert_emp;







create or replace procedure insert_emp(

  cempno in number,

  cename in varchar2,

  cjob in varchar2,

  cmgr in number,

  chiredate in date,

  csal in number,

  ccomm in number,

  cdeptno in number

) as

begin

  insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)

  values(cempno,cename,cjob,cmgr,chiredate,csal,ccomm,cdeptno);

end insert_emp;







set serveroutput on;

begin

   insert_emp(cempno=>7377,cename=>'mjjj',cjob=>'stu',cmgr=>7777,chiredate=>to_date('2011-01-01','YYYY-MM-dd'),csal=>5000,ccomm=>1000,cdeptno=>20);

end;











set serveroutput on;

begin

   insert_emp(3333,'mjjj','stu',7777,to_date('2011-01-01','YYYY-MM-dd'),5000,1000,20);

end;













set serveroutput on;

begin

   insert_emp(9999,cename=>'mjjj',cjob=>'stu',cmgr=>7777,chiredate=>to_date('2011-01-01','YYYY-MM-dd'),csal=>5000,ccomm=>1000,cdeptno=>20);

end;































declare



 

begin

    dbms_output.put_line('开始');

   

    delete from emp where empno=7934;

  

   dbms_output.put_line('结束');

end;

/






  


游标sql语句


更多文章、技术交流、商务合作、联系博主

微信扫码或搜索:z360901061

微信扫一扫加我为好友

QQ号联系: 360901061

您的支持是博主写作最大的动力,如果您喜欢我的文章,感觉我的文章对您有帮助,请用微信扫描下面二维码支持博主2元、5元、10元、20元等您想捐的金额吧,狠狠点击下面给点支持吧,站长非常感激您!手机微信长按不能支付解决办法:请将微信支付二维码保存到相册,切换到微信,然后点击微信右上角扫一扫功能,选择支付二维码完成支付。

【本文对您有帮助就好】

您的支持是博主写作最大的动力,如果您喜欢我的文章,感觉我的文章对您有帮助,请用微信扫描上面二维码支持博主2元、5元、10元、自定义金额等您想捐的金额吧,站长会非常 感谢您的哦!!!

发表我的评论
最新评论 总共0条评论