oracle 10g ´æ´¢¹ý³Ì ÎÊÌâ

ÎÒÔÚ¿ØÖÆ̨Ï´´½¨ÁËÒ»¸ö´æ´¢¹ý³Ì£º

create procedure myProc as
begin
dbms_output.put_line('hello world!');
end

È»ºóÔÙ ²éѯʱ£¬²¢Ã»Óиô洢¹ý³Ì£º
select * from user_procedures;

È»ºó ÓÃ:
exec myProcʱ³ö´í£¬Ìáʾ£º¶ÔÏóÎÞЧ

ÇëÎÊʲôԭÒò£¬¸ÃÔõô×ö£¬Ð»Ð»

---

create procedure myProc as
begin
dbms_output.put_line('hello world!');
end;

Â¥Ö÷ÉÙÁ˸ö·ÖºÅ£¬Ã»±àÒë³É¹¦

---

end ºóÃæÒª¼Ó¸ö·ÖºÅ¡£

---

ÎÒÔËÐдúÂëʱ¼ÓÁ˷ֺŵÄ

---

LZûÓбàÒëºÃ~
²»ÖªµÀLZʹÓÃʲô¹¤¾ß~
Èç¹ûÊÇsqlplusòËÆÐèÒªÔÚ×îºó¼Ó¡°/¡±À´Ö´Ðеġ£

---

´´½¨³É¹¦ÁË£¬·Ç³£¸Ðл

---

¶¥ÎåÂ¥£¡

SQL> create or replace procedure myProc
  2 as
  3 begin
  4 dbms_output.put_line('hello world!');
  5 end;
  6 /

¹ý³ÌÒÑ´´½¨¡£

SQL> exec myProc;

PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£

SQL> set serveroutput on
SQL> /

¹ý³ÌÒÑ´´½¨¡£

SQL> exec myProc;
hello world!