Hello Everyone!
Just to make you smile and let you remember all those sweet holidays I would like to congratulate you and wish you MERRY CHRISTMAS! in Oracle style:
set lines 180 pages 1000 select decode(sign(rownum-24),-1, replace(replace(lpad(' ', 25 - rownum+trunc(rownum / 8) * 3, ' ') || rpad('^', rownum * 2 - 1 - trunc(rownum / 8) * 6, '^') || rpad(' ', 25 - rownum+trunc(rownum / 8) * 3, ' '),' ^^^',' ^o^'),'^^^ ','^o^ '), lpad(' ', 23, ' ') || rpad('^', 3, '^') || rpad(' ', 23, ' ') ) "MERRY CHRISTMAS!" from dual connect by rownum select decode(sign(rownum-24),-1, > replace(replace(lpad(' ', 25 - rownum+trunc(rownum / 8) * 3, ' ') || > rpad('^', rownum * 2 - 1 - trunc(rownum / 8) * 6, '^') || > rpad(' ', 25 - rownum+trunc(rownum / 8) * 3, ' '),' ^^^',' ^o^'),'^^^ ','^o^ '), > lpad(' ', 23, ' ') || > rpad('^', 3, '^') || > rpad(' ', 23, ' ') > ) "MERRY CHRISTMAS!" > from dual > connect by rownum
The SQL was written some time ago together with friend of my Maris Elsins
PS I am sure you have you own version somewhere in your library.
Have a great year everyone!
Yury
No comments