database schema
database schema

HAPPY HOLIDAYS * SQL CODE *

 

 

set pages 1000

select decode

( sign(floor(Mx.MaxWidth /2)-rownum)

, 1

, lpad( ' ', floor(Mx.MaxWidth /2)-(rownum-1)) || rpad( '*', 2*(rownum-1)+1, ' *')

, lpad( '* * *', floor(Mx.MaxWidth/2)+3)

) as "!!! HAPPY HOLIDAYS !!!"

from all_tables, (select 60 as MaxWidth from dual) Mx

where rownum < floor(Mx.MaxWidth /2) + 6;