select '一','二' from dual         
union all                                 
select '三','四' from dual         
union all                                 
select '五','六' from dual         
union all                                 
select '七','八' from dual         
union all                                 
select '九','十' from dual   

转自：http://www.cnblogs.com/xieon1986/archive/2012/11/26/2789226.html