Hi everyone,
Can someone please help me. I want to know what will be the output of the following statement -
SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL
Thanks
gsrai31
Printable View
Hi everyone,
Can someone please help me. I want to know what will be the output of the following statement -
SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL
Thanks
gsrai31
Why don't you run it and check it.
Thanks for your suggestion. I dont have access to Oracle at the moment. I have tried testing it with MS Access but it did not work as Access does not support some the SQL function used in this statement. I have only started learning Oracle for last few weeks with training DVDs.
Troublethetrouble
Thank You.
No, it is TROUBLETHETROUBLE.Quote:
Originally Posted by ingalesd