1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Replacing more then one String with null

Discussion in 'SQL PL/SQL' started by Tariq Bashir Malhi, Jun 22, 2010.

  1. Tariq Bashir Malhi

    Tariq Bashir Malhi Forum Advisor

    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    80
    I am facing a simple problem, but could not resolve as yet, i want to replace two string 'M/S' and ' " ' with null, i know this command
    Code (SQL):
     SELECT REPLACE(' " M/S Private linker " ','M/S',NULL) FROM dual
    Which command i should use
     
  2. Tariq Bashir Malhi

    Tariq Bashir Malhi Forum Advisor

    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    80
    Problem Resolved