Home » SQL & PL/SQL » SQL & PL/SQL » retrieve data without symbol '(single quote)
retrieve data without symbol '(single quote) [message #286888] Mon, 10 December 2007 06:27 Go to next message
raghunalumachu
Messages: 12
Registered: November 2007
Location: MUMBAI
Junior Member
Hi,

I am having a database column where i have records inserted using front end which have the symbol ' in it. But while retrieving i would like to replace the symbol with null.


For example i am having a table called members with one column member name


membername
----------
kiran
ajay's
kumar
mohan's


while retrieving i want to get only kiran ,ajays,kumar,mohans etc but not the quote symbol.

I am using the following query


select replace(membername, ''''' ,'null' ) from members;

But i am getting an error quoted string not properly terminated

So pleasehelp me in this regard

Thanks in Advance

Raghu
Re: retrieve data without symbol '(single quote) [message #286890 is a reply to message #286888] Mon, 10 December 2007 06:35 Go to previous messageGo to next message
hobbes
Messages: 173
Registered: January 2006
Senior Member
- The second argument should have one ' less
- NULL should not be in quotes!
Re: retrieve data without symbol '(single quote) [message #286891 is a reply to message #286888] Mon, 10 December 2007 06:38 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.

If is impossible to see the difference between '' and ".

Always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Cacading Triggers
Next Topic: Oracle Analytic Function Issue
Goto Forum:
  


Current Time: Sat Dec 03 01:23:23 CST 2016

Total time taken to generate the page: 0.11966 seconds