查詢條件的變量名和列名一樣會出錯。會把表中的所有數據查出

 

-- Created on 2009/4/30 by JACKY_BIN

declare

  -- Local variables here

  i integer;

  eid varchar2(30);

  employee_id varchar2(30);

begin

  -- Test statements here

  select t.employee_id into eid

  from basicdata_employee t

  where t.employee_id = employee_id;  --會出錯

 

  dbms_output.put_line('id = '||eid);

 

end;