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
Messages: 12
Registered: November 2007
Location: MUMBAI
Junior Member

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


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

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
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: 63908
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).

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

Current Time: Fri Oct 21 06:17:49 CDT 2016

Total time taken to generate the page: 0.09928 seconds