Re: Merry Christmas

From: HansF <News.Hans_at_telus.net>
Date: Fri, 23 Dec 2005 19:49:08 GMT
Message-Id: <pan.2005.12.23.19.49.07.396757@telus.net>

On Fri, 23 Dec 2005 11:11:58 -0800, Joel Garry wrote:

> set heading off
> set feedback off
> set pagesize 2000
> 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
> /

ANd it even seems to be version independent (to 10gR2 XE)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Fri Dec 23 2005 - 13:49:08 CST