What will be the output of the following query?

SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;

TROUBLETHETROUBLE

  • Interview Candidate
  • 6
  • 6572

Showing Answers 1 - 6 of 6 Answers

iamnogeek

  • Jul 12th, 2007
 

The final result replaces "A" and "N" by "TROUBLE". So answer should be TROUBLETHETROUBLE, without any spaces in between..

  Was this answer useful?  Yes

sharathtest

  • Aug 16th, 2007
 

The result is ' TROUBLETHETROUBLE ' Space before and after the text.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions