Oracle ÏÔʽÓαê

--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
       --ÉùÃ÷Óαê
       cursor mycur is select * from employees where employee_id<120;
       --¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓڴ洢ij¸ö±íµÄÒ»Ìõ¼Ç¼
       rowdata employees%rowtype;
--Ö´Ðв¿·Ö
begin
       --´ò¿ªÓαê
       open mycur;
       loop
            --ÔÚÑ­»·ÖÐÓÃfetchÌáÈ¡¼Ç¼
            fetch mycur into rowdata;
            dbms_output.put_line('salary:'||rowdata.salary||'    '||'hire_date:'||rowdata.hire_date||'    '||'first_name:'||rowdata.first_name);
            --ÓÃ%notfoundÊôÐÔ¼ì²âÊÇ·ñµ½×îºóÒ»Ìõ¼Ç¼
            exit when mycur%notfound;
       end loop;
       --Ìá½»ÊÂÎñ;
       commit;
       --¹Ø±ÕÓαê
       close mycur;
--Òì³£²¿·Ö
exception
       --ÓÐÒì³£Ôò»Ø¹ö
       when others then
       rollback;
end;
/
--------------------²ÎÊýÓαê
--²éѯÊý¾Ý
select * from employees where salary<=10000;
--¶¨Ò岿·Ö
declare
       --¶¨ÒåÓαꣻעÒ⣺²ÎÊýÀàÐÍ(input_salary)²»ÐèÒªÖ¸¶¨¾«¶È
       cursor mycur(input_salary number) is select * from employees where salary<input_salary;
       --¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓÚ´æ´¢Ä