select * from tabel1 rs.lastRow(); rs.getRow(); rs.beforeFirst();
create or replace procedure test_sel ( int_return out number --返回记录总数 ) as cursor cs1 is select * from emp ; desc_job varchar2(100), begin for for_cs1 in cs1 loop desc_job := cs1.job ; int_return := cs1%rowcount ; end; end;
rs.lastRow();
rs.getRow();
rs.beforeFirst();
(
int_return out number --返回记录总数
)
as
cursor cs1 is
select * from emp ;
desc_job varchar2(100),
begin
for for_cs1 in cs1
loop
desc_job := cs1.job ;
int_return := cs1%rowcount ;
end;
end;