create or replace procedure query_year (y in number)
as
begin
select * from tmp where year=y ;end ;
上面的存储过程有什么问题?怎么修改?我是初学,希望能讲的详细些。
as
begin
select * from tmp where year=y ;end ;
上面的存储过程有什么问题?怎么修改?我是初学,希望能讲的详细些。
as
a emp%rowtype;
begin
select * into a from tmp where year=y ;
end ;
create or replace procedure query_year (y in number)
as
a emp%rowtype;
begin
select * into a from tmp where year=y ;
end ;
确实可用了。但是还是不太明白。我下了挺多教程,版本儿都不一样。郁闷。
as
begin
execute immediate 'select * from tmp where year='||y ;end ;
--orcreate or replace procedure query_year (y in number)
as
a tmp%rowtype;
begin
select * into a from tmp where year=y ;end ;