declare cursor cur(id in varchar2) is select * from tableb bb where bb.sid=id; tb tableb%rowtype; begin open cur('02'); loop fetch cur into tb; exit when cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE(tb.fid || ' ' || tb.name || ' ' || tb.state ||' ' || tb.sid ); end loop; close cur; end;
fetch 用法
最新推荐文章于 2024-03-01 16:05:49 发布