Oracle sql

I am running a comma delimited extract in Oracle using sql.  Some of the data has double quotes or single quotes and i do not want those to show up in the extract.  How do i ask Oracle to pull the text with out the quote.  Here is an example of the data in the DESCRIPTION field:

DESCRIPTION
Run Off Election for '8/2/2011 - Primary Election'
restockettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sdstuberConnect With a Mentor Commented:



select replace(description,'''') from your_table


that's 4 single quotes
0
 
restockettAuthor Commented:
That works!!!!What can i say but thinks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.