create or replace procedure pro_demo as
begin
dbms_output.put_line('hello');
end pro_demo;
/
set serveroutput on;
exec pro_name;
begin
dbms_output.put_line('hello');
end pro_demo;
/
set serveroutput on;
exec pro_name;
begin
dbms_output.put_line('hello world');
end;
/set serveroutput on;
exec helloworld;
excute procedurename;回车执行!
isbegin
insert into sc(c#) values(id);end aaa;调用
declare
str varchar2(20);
begin
aaa(str);
end;
/
如果是没有参数的存储过程,直接调用就可以 exec proc;
比如; select * from tbl