oracle – 批處理(sql語句塊)

格式：

View Code

 declare   msg    varchar2(32);   p_name varchar2(32);   outresult varchar2(64); begin   p_name := 'xxxx';   select loginname into MSG from users where loginname = p_name and 1=2;   dbms_output.put_line(MSG); exception   when others then     outresult := 'failure---' || sqlerrm || '   ' || p_name;     dbms_output.put_line(outresult); end;

1.只能自declare之後begin之前聲明變數或聲明並賦值

2.字元類型的變數必須聲明其精度