A Christmas Query
- by Gilles Haro
Let’s celebrate Christmas with this absolutely useless query ! with Mx as (select 60 as MaxWidth from dual) 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_tables, Mx where rownum < floor(MaxWidth /2) + 6; Merry Christmas ! Gilles Haro Technical Expert - Core Technology, Oracle Consulting