with tt as(select 1 a,1 b ,1 c ,1 d from dual)select * from( select * from tt union all select null,null,null,null from dual connect by rownum<16 order by 1 nulls last) where rownum<=15
修改下 with tt as(select rownum a,1 b ,1 c ,1 d from dual connect by rownum<20)select * from( select * from tt union all select null,null,null,null from dual connect by rownum<16 order by 1 nulls last) where rownum<=15 or a is not null 楼主可以将with as测试数据中的rownum<20改成rownum<10试试 给个例子,楼主试着按自己需要修改
select * from tt
union all
select null,null,null,null from dual connect by rownum<16
order by 1 nulls last)
where rownum<=15
with tt as(select rownum a,1 b ,1 c ,1 d from dual connect by rownum<20)select * from(
select * from tt
union all
select null,null,null,null from dual connect by rownum<16
order by 1 nulls last)
where rownum<=15 or a is not null
楼主可以将with as测试数据中的rownum<20改成rownum<10试试
给个例子,楼主试着按自己需要修改