用sql或者pl/sql语句实现:
*
***
*****
*******
方法有如下:
Select lpad('*',Rownum*2 -1,'*') From dual
Connect By Rownum <5
Select lpad('*',Rownum*2 -1,'*') From all_objects
select rownum ,substr(sys_connect_by_Path(null,'**'),2)
from dual connect by rownum<100
阅读(702) | 评论(0) | 转发(0) |