I am creating scripts that will SELECT data from each table in our
database and create the INSERT statements that would be needed to
rebuild the database. The problem that I am currently having is that
some of my varchar2 fields have single quotes in them. When I create
the insert statement, I get something like this:
INSERT INTO EMP values (1234, 'Mc'Govern', ...)
because Mc'Govern had a quote in his name.
My question: is there a generic way that I can "escape" the quotes, so
that I don't have to go thru with an editor or awk to get rid of them? Using
a decode didn't work, since it is not known how many single quotes could
possibly exist in a single text string.
Thanks in advance,
Lorrie Gagnon
Digital Systems Research, Inc.