mhinze.com archive

select decode
       ( sign(floor(maxwidth/2)-rownum)
       , 1, lpad( ' ', floor(maxwidth/2)-(rownum-1))
       || rpad( '*', 2*(rownum-1)+1, ' *')
       , lpad( '* * *', floor(maxwidth/2)+3))
from all_objects, (select 40 as maxwidth from dual)
where rownum < floor(maxwidth/2) +5;

This entry was posted on Thursday, November 29th, 2007 at 2:57 pm and is filed under Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.