Oracle DBA & DEV: MERRY CHRISTMAS!

Posted in: Technical Track

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

email
Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Yury is a nice person who enjoys meeting and working with people on challenging projects in the Oracle space. He started to work as an Oracle DBA 14 years ago (1997). For the past 10 years (since 2001) his main area of expertise is Oracle e-Business Suite. Yury is an OCP 7,8,9,10g and OCM 9i,10g. He is a frequent presenter at Oracle related conferences such as Hotsos, UKOUG and AUOUG. Yury is a socially active person. Apart from Social Media (Twitter, Bloging, Facebook) he is the primary organizer of Sydney Oracle Meetup group (250 people). So if you happen to be in Sydney (Australia) drop Yury a message and stop by at one of his Meetups.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *