PL\SQL 实战存储过程

1.存储过程

CREATE or replace procedure pro_first (transpalceid in number) as
transname tms_transplace.transplacename%type;
begin
select t.transplacename into transname from tms_transplace t where t.transplaceid = transpalceid;
–dbms_output.put_line(‘地点名称’ || transname );
end;
直接在sql窗口写好存储过程,执行就行,刷新即能看到所写的存储过程

2.调用存储过程

1.法一:

call pro_first (818);

2.法二:

begin 
    pro_first (818);
end;

3.存储过程的理解只要仿照java程序的理解,那么就比较简单