oracle´æ´¢¹ý³ÌÔõôÊä²»³ö´ð°¸

declare
v_name exwarehouse.goodsname%type;
v_a exwarehouse.amount%type;
begin
select goodsname,amount
into v_name,v_a
from exwarehouse
where exwarehouse.id='20091012091729';
dbms_output.put_line(v_name);
dbms_output.put_line(v_a);
end;

Õâ¶Î´úÂë±àÒë³É¹¦£¬ÔõôÔÚpl\sqlÖÐûÓÐÊä³ö½á¹û£¿ÎÒÔÚ¿ØÖÆ̨û¿´µ½¡£¡£¡£

---

sf

---

set serverout on

---

Ö´ÐÐÕâ¶Î¹ý³ÌÇ°ÏÈÖ´ÐÐÏ£º
set serveroutput onÊÔÊÔ¿´

---

±àÒëºóÔËÐÐû£¿

ÔËÐÐÇ°set serveroutput onÁËû£¿

---

set serveroutput on

---

¿ÉÄÜÍüÁËSET SERVEROUTPUT ON

---

set serveroutput on;