qlsql oracle 怎么把大于某字段小于某字段的数据排成一列
答案:3 悬赏:20
解决时间 2021-02-15 04:38
- 提问者网友：暖心后
- 2021-02-14 05:17
qlsql oracle 怎么把大于某字段小于某字段的数据排成一列
最佳答案
- 二级知识专家网友：万千宠爱
- 2021-02-14 05:56
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;
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;
全部回答
- 1楼网友：不服输的倔强
- 2021-02-14 07:03
用存储过程做吧..
- 2楼网友：一池湖水
- 2021-02-14 06:16
写个过程吧。单纯的sql搞不出来。
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯