Home » Other » Community Hangout » Merry Christmas (merged)
Merry Christmas (merged) [message #283390] Tue, 27 November 2007 00:33 Go to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

SELECT TRANSLATE ('_9(89$7.;%-.1@@.14=1$35.=5*;.81^^;.$5_;51*',
                                    '1234567890!@#$%^&*()-=_+;,.',
                                    'ABCDEFGHIJKLMNOPQRSTUVWXYZ '
) ADVANCE_WISHES FROM DUAL;


Regards,
Kiran Aithal.

[Updated on: Tue, 27 November 2007 00:45]

Report message to a moderator

Re: WISHES IN ADVANCE! [message #283392 is a reply to message #283390] Tue, 27 November 2007 00:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

SQL> SELECT TRANSLATE ('_9(89$7.;%-.1@@.141$35.=5*;.81^^;.$5_;51*',
  2                                      '1234567890!@#$%^&*()-=_+;,.',
  3                                      'ABCDEFGHIJKLMNOPQRSTUVWXYZ '
  4  ) ADVANCE_WISHES FROM DUAL;

ADVANCE_WISHES
-----------------------------------------
WISHING YOU ALL [b]ADANCE[/b] VERY HAPPY NEWYEAR

Bug: ADANCE instead of ADVANCE Smile
Re: WISHES IN ADVANCE! [message #283397 is a reply to message #283390] Tue, 27 November 2007 00:45 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

SELECT TRANSLATE ('_9(89$7.;%-.1@@.14=1$35.=5*;.81^^;.$5_;51*',
                                    '1234567890!@#$%^&*()-=_+;,.',
                                    'ABCDEFGHIJKLMNOPQRSTUVWXYZ '
) ADVANCE_WISHES FROM DUAL;



Fixed!

Thank you Smile

Kiran.
Re: WISHES IN ADVANCE! [message #283403 is a reply to message #283390] Tue, 27 November 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SET PAGESIZE 0
SET FEEDBACK OFF
DEFINE width=20
WITH
  lines AS ( 
    SELECT ROWNUM rn FROM DUAL CONNECT BY LEVEL < &width+16
  )
SELECT DECODE(
         SIGN(ROWNUM-&width-5),
              -1, LPAD(RPAD('*',3-2*ABS(3-ROWNUM),'*'),
                       &width+5-ABS(3-ROWNUM))||
                  LPAD(' ',&width-ROWNUM+8)||RPAD('*',2*(ROWNUM-4),' *')||
                  LPAD(RPAD('*',3-2*ABS(6-ROWNUM),'*'),
                       &width-ROWNUM-ABS(6-ROWNUM))||
                  LPAD('*',
                       DECODE(SIGN(ROWNUM-3*&width/4+3),-1,0,3*&width/4-ROWNUM)),
       DECODE(
         SIGN(ROWNUM-&width-11),
              -1, LPAD('***', &width+5),
       DECODE(
         SIGN(ROWNUM-&width-12),
              0, TRANSLATE(LPAD('BBB@?;5-24@;-*@BBB',&width+13,'@'),
                   '@Q"(-_)=*<,;:!1234567890+?./%#[|\]}{>AB',
                   ' abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ*'),
       DECODE(
         SIGN(ROWNUM-&width-14),
              0, TRANSLATE(LPAD('"-*',2*&width+3,'@'),
                   '@Q"(-_)=*<,;:!1234567890+?./%#[|\]}{>AB',
                   ' abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ*')
             )))) l
FROM lines
/

Cool
Regards
Michel

Re: WISHES IN ADVANCE! [message #283406 is a reply to message #283403] Tue, 27 November 2007 01:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Shocked that is really great
Query Output.

                       *
                      ***
                       *
                       *              *
                      * *            ***
                     * * *            *
                    * * * *
                   * * * * *
                  * * * * * *
                 * * * * * * *
                * * * * * * * *   *
               * * * * * * * * *  *
              * * * * * * * * * * *
             * * * * * * * * * * *
            * * * * * * * * * * * *
           * * * * * * * * * * * * *
          * * * * * * * * * * * * * *
         * * * * * * * * * * * * * * *
        * * * * * * * * * * * * * * * *
       * * * * * * * * * * * * * * * * *
      * * * * * * * * * * * * * * * * * *
     * * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * * * *
                      ***
                      ***
                      ***
                      ***
                      ***
                      ***

              *** Xoyeux Noel ***

                                     Michel


Wish You very happy X-MAS and New Year.
Re: WISHES IN ADVANCE! [message #283410 is a reply to message #283406] Tue, 27 November 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh! How can you have a X instead of J in "Joyeux Noel" (Merry Christmas in French)?

Michel
Re: WISHES IN ADVANCE! [message #283412 is a reply to message #283410] Tue, 27 November 2007 01:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

How can you have a X instead of J in "Joyeux Noel" (Merry Christmas in French)?
Because I am not french Smile

Becuase of NLS_LANG setting.
SQL> show parameter nls_lang

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
nls_language                         string      AMERICAN
Re: WISHES IN ADVANCE! [message #283413 is a reply to message #283390] Tue, 27 November 2007 01:21 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Simply Great !!!
Re: WISHES IN ADVANCE! [message #283414 is a reply to message #283390] Tue, 27 November 2007 01:25 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Awesome! Proud

Regards,
Kiran.
Re: WISHES IN ADVANCE! [message #283450 is a reply to message #283414] Tue, 27 November 2007 03:35 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
http://www.orafaq.com/forum/fa/450/0/

Apart from the Xoyeux Noel that is... Very Happy. Just kidding Michel, it's indeed amazing!

MHE
Re: WISHES IN ADVANCE! [message #283453 is a reply to message #283450] Tue, 27 November 2007 03:41 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But, why aren't there any blinking light bulbs? Wink Just kidding; it is really, REALLY amazing!
Re: WISHES IN ADVANCE! [message #283633 is a reply to message #283453] Tue, 27 November 2007 15:18 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
gorgeous!!!!!!! Thumbs Up

It will start blinking From 20th of DEC Wink

[Updated on: Tue, 27 November 2007 15:19]

Report message to a moderator

Merry Christmas [message #289615 is a reply to message #283390] Mon, 24 December 2007 05:50 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member



Wish You All A

./fa/3634/0/



regards,
  • Attachment: APC171_S.jpg
    (Size: 6.95KB, Downloaded 443 times)
Re: Merry Christmas [message #289643 is a reply to message #289615] Mon, 24 December 2007 13:09 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Merry Christmas!
Happy New Year!!
Previous Topic: Top 10 Largest databses in the World
Next Topic: Happy New Year
Goto Forum:
  


Current Time: Thu Dec 08 02:14:30 CST 2016

Total time taken to generate the page: 0.07190 seconds