create or replace procedure t is
begin
insert into a
select * from b ;
end t;上面的可以编译,下面的就不可以编译?报 PLS-00103 错,为何?
create or replace procedure t is
begin
insert into a
select * from b order by col1 ;
end t;
begin
insert into a
select * from b ;
end t;上面的可以编译,下面的就不可以编译?报 PLS-00103 错,为何?
create or replace procedure t is
begin
insert into a
select * from b order by col1 ;
end t;
但是为何在存储过程中编译报错。单独执行确可以
insert into a
select * from b order by col1 ;
是不是缺了个";"insert into a ;
因为在sqlplus里面执行是可以的:
insert into a
select * from b order by col1 ;
为何单独执行却可以
insert into a
select * from b order by col1 ;