Results 1 to 6 of 6

Thread: SQL Query help

  1. 09-26-2007, 12:50 PM #1
    gsrai31
    gsrai31 is offline Registered User
    Join Date
    Jul 2004
    Posts
    13

    SQL Query help

    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
    Reply With Quote Reply With Quote
  2. 09-27-2007, 09:45 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Why don't you run it and check it.
    Reply With Quote Reply With Quote
  3. 09-27-2007, 10:51 AM #3
    gsrai31
    gsrai31 is offline Registered User
    Join Date
    Jul 2004
    Posts
    13

    SQL Query help

    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.
    Reply With Quote Reply With Quote
  4. 09-27-2007, 10:37 PM #4
    ingalesd
    ingalesd is offline Registered User
    Join Date
    Sep 2007
    Posts
    1
    Troublethetrouble
    Reply With Quote Reply With Quote
  5. 09-28-2007, 03:07 AM #5
    gsrai31
    gsrai31 is offline Registered User
    Join Date
    Jul 2004
    Posts
    13

    SQL Query help

    Thank You.
    Reply With Quote Reply With Quote
  6. 10-02-2007, 01:39 AM #6
    stecal
    stecal is offline Registered User
    Join Date
    Oct 2005
    Posts
    2,557
    Quote Originally Posted by ingalesd
    Troublethetrouble
    No, it is TROUBLETHETROUBLE.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules