一个pl/sql中可以代替游标的写法（用这种方法也可以实现象sql中top的效果）
declare
msg_ varchar2(1000);
i number;
begin
select count(*) into i from c_m_config;
for j in 1 .. i loop
select A.CONFIG_CD
into msg_
from (select c_m_config.*, rownum as rownumber from c_m_config) A
where A.rownumber = j;
end loop;
end;
posted on 2007-12-12 15:14
宏宇 阅读(104)
评论(0) 编辑 收藏