toad oracle ´æ´¢¹ý³Ì£¿

toadϵÄoracle´æ´¢¹ý³ÌÔõôд


²éѯµÄ´ø²ÎÊýµÄ

---

SQL> create or replace procedure pro(name varchar2) is
  2  a varchar2(20);
  3  begin
  4  select name into a from dual;
  5  dbms_output.put_line(a);
  6  end;
  7  /

Procedure created

SQL> exec pro('aaa');
aaa

---

ÒýÓÃ

SQL> create or replace procedure pro(name varchar2) is
  2  a varchar2(20);
  3  begin
  4  select name into a from dual;
  5  dbms_output.put_line(a);
  6  end;
  7  /

Procedure created

SQL> exec pro('aaa');
aaa

֮ǰset serveroutput on;

---

dbms_output.put_line(a);  ʲôÒâ˼£¿

´ø²ÎÊýÁË ²éѯÌõ¼þÔõôûÓÐwhere

---

create or replace procedure pro(name varchar2) is
ºìÉ«²ÎÊý
×Ô¼ºÏÈ¿´µã»ù´¡Êé¼®°¡!!!!!