SQL> select decode
2 ( sign(floor(maxwidth/2)-rownum)
3 , 1, lpad( ' ', floor(maxwidth/2)-(rownum-1))
4 || rpad( '*', 2*(rownum-1)+1, ' *')
5 )
6 from all_objects,
7 (select 10 as maxwidth from dual)
8 where rownum < floor(maxwidth/2) +1;
DECODE(SIGN(FLOOR(MAXWIDTH/2)-ROWNUM),1,LPAD('',FLOOR(MAXWIDTH/2)-(ROWNUM-1))||R
--------------------------------------------------------------------------------
*
* *
* * *
* * * *
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22664653/viewspace-669552/ ，如需转载，请注明出处，否则将追究法律责任。
