create or replace procedure proc1
is
p_name sut.name%type;
begin
select name into p_name from sut where id='12072226';
dbms_output.put_line(p_name);
end proc1;
is
p_name sut.name%type;
begin
select name into p_name from sut where id='12072226';
dbms_output.put_line(p_name);
end proc1;
/
注意定义方式