create or replace myproc as name varchar2(12); begin select * from mytable; end;------------------- 我主要想演示一下存储过程可是不正确我想请教一下oracle过程中必需在 select 语句中嵌入变量吗?如: select mytable.name into name from mytable;请高手指教
create or replace trigger myproc as name varchar2(12); begin select * from mytable; end;
create or replace procedure myproc --少了关键字procedure as name varchar2(12); begin name := 'I love you'; --付值方式一 select mytable.name into name from mytable; --方式二,给变量付值,要确保select的值是唯一. end;
create or replace trigger myproc
as
name varchar2(12);
begin
select * from mytable;
end;
as
name varchar2(12);
begin
name := 'I love you'; --付值方式一
select mytable.name into name from mytable; --方式二,给变量付值,要确保select的值是唯一.
end;