我有一个MSSQL存储过程,代码如下:
create procedure sel_emp
as
begin
select bh,xm,bdr into #temp from employee
select * from #temp --临时表
end
现在要把这个存储过程写在ORACLE数据库里应该如何写呢?!望各们高手指点!
create procedure sel_emp
as
begin
select bh,xm,bdr into #temp from employee
select * from #temp --临时表
end
现在要把这个存储过程写在ORACLE数据库里应该如何写呢?!望各们高手指点!
zhanghaopeng[email protected]