如何在存储过程中 .....

Question

select project_id into project_id from table;

Answer 1

我知道是 select project_id into project_id from table;
关键我这么定了，是不是 就能把结果赋到里面去啊
还是要怎么执行一下菜可以？

Answer 2

create or replace procedure p_getproject_id as 
  project_id number(10);
begin
  select project_id into project_id from table;
  dbms_output.put_line (project_id);
end;
/

Answer 3

http://community.csdn.net/Expert/topic/5036/5036807.xml?temp=.6208307