13问答网 > qlsql oracle 怎么把大于某字段小于某字段的数据排成一列

qlsql oracle 怎么把大于某字段小于某字段的数据排成一列

2025-04-14 16:42:00

推荐回答（1个）

回答1：

create table mm (a number(10),b number(10));
create table nn (c number(10));
insert into mm values (1,3);
insert into mm values (7,9);
commit;

declare
begin
for r in (select a,b from mm) loop
insert into nn select * from (select row_number() over(order by a.object_id) rn from dba_objects a) t where t.rn between r.a and r.b;
end loop;
commit;
end;