;
dbms_output.put_line(¡®student_id¡¯||studenta);
exit when student_list%notfound;
dbms_output.put_line(¡®ÒѾµ½Îļþβ£¡¡¯);
end loop;
close student_list;
end;
5¡¢ ´æ´¢¹ý³ÌÊÇʲô£¬ÎªÊ²Ã´±ÈÒ»°ãÓï¾ä¸ü¿ì£¬Ð´Ò»¸ö¼òµ¥µÄ´æ´¢¹ý³Ì¡£
¶¨Ò壺¹ý³Ì£¨procedure£©ÊÇÒ»¸öPL/SQLÓï¾ä¿é£¬Ëü´æ´¢ÔÚÊý¾Ý×ÖµäÖв¢¿É±»Ó¦ÓóÌÐòµ÷Ó㬿ÉÒÔʹÓùý³Ì´æ´¢Êý¾Ý¿âÖÐƵ·±Ê¹ÓõÄÓ¦ÓÃÂß¼¡££¨Ê¹Óô洢¹ý³ÌµÄÒ»¸öºÃ´¦ÊÇÄܹ»ÊµÊ©Êý¾ÝµÄ°²È«ÐÔ£©
ÔÒò£ºÒòΪ´æ´¢¹ý³ÌÊÇÔ¤±àÒëµÄ£¬ËùÒÔ±ÈÒ»°ãµÄÓï¾ä¸ü¿ì¡£
Àý×Ó1£º
create or replace procedure print_current_time as
curtime varchar2(20);
begin
select to_char(sysdate,¡¯yyyy/mm/dd hh24:mi:ss¡¯)
into curtime
from dual;
dbms_output.put_line(¡®µ±Ç°Ê±¼äÊÇ£º¡¯||chr(9)||curtime);
end print_current_time;
Àý×Ó2£º
create or replace procedure print_parameter
(
p_Parameter in varchar2 default null
)
as
begin
if(p_Parameter is null) then
dbms_output.put_line(¡®ÄãûÓÐÊäÈë²ÎÊý¡¯);
else
dbms_output.put_line(¡®ÄãÊäÈëµÄ²ÎÊýÊÇ£º¡¯||chr(9)||p_Parameter);
end if;
end print_parameter;