SQL Query

[spicysudhi]

Hi all,

select TRANSLATE('_9(8.-.=5*;.81^^;.=1@5$)9$5.41;','1234567890!@#$%^&*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ) FROM dual;


regards,
Sudhi

(apologies for the delay in posting...)

 

[himridul]

Hi Sudhi,

select TRANSLATE(')81$!.-.=5*;.#-38.(-489','1234567890!@#$%^&*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ) FROM dual;

 

[SantaMufasa]

Sudhi and Himridul,

Unless you put this thread and your replies in some sort of context, this will soon all get "red-flagged". To what do these posts relate?

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:39 (16Feb04) UTC (aka "GMT" and "Zulu&quot, 11:39 (16Feb04) Mountain Time)

 

[dbtoo2001]

Looks like two friends to me....

SQL> select TRANSLATE('_9(8.-.=5*;.81^^;.=1@5$)9$5.41;','1234567890!@#$%^&*()-=_+;,.',
2 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ) FROM dual;

TRANSLATE('_9(8.-.=5*;.81^^;.=1
-------------------------------
WISH U VERY HAPPY VALENTINE DAY


SQL> select TRANSLATE(')81$!.-.=5*;.#-38.(-489','1234567890!@#$%^&*()-=_+;,.',
2 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ) FROM dual;

TRANSLATE(')81$!.-.=5*;
-----------------------
THANK U VERY MUCH SUDHI


SQL>

 

[SantaMufasa]

Duh, I should have just executed the code. Didn't mean to interfere with Sudhi's and Himridul's "Valentining".

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:52 (16Feb04) UTC (aka "GMT" and "Zulu&quot, 11:52 (16Feb04) Mountain Time)