假设a表有列c1, c2, c3select * from (select c1, c2, c3 from a union all select null, null, null from all_objects where rownum<9 ) where rownum < 9;=========================== oldwain --------------------------- http://www.itpub.net/index.php?referrerid=32 http://www.linuxforum.net/forum/postlist.php?Cat=&Board=oracle http://www.oraclefan.net/
(select c1, c2, c3 from a
union all
select null, null, null from all_objects where rownum<9
)
where rownum < 9;===========================
oldwain
---------------------------
http://www.itpub.net/index.php?referrerid=32
http://www.linuxforum.net/forum/postlist.php?Cat=&Board=oracle
http://www.oraclefan.net/