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

Bhuvaneswari.V

 Profile Answers by Bhuvaneswari.V Questions by Bhuvaneswari.V

• Aug 22nd, 2009

The rtrim function requires 1 argument(s).

sharathtest

• Aug 16th, 2007

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

Answer Question  Select Best Answer