Automatic handling of quotes in inesrt statement

From: Lorrie Gagnon <gagnon_at_dsr.com>
Date: Thu, 22 Dec 1994 20:06:00 GMT
Message-ID: <D18AI0.LBr_at_crash.cts.com>

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.
gagnon_at_dsr.com Received on Thu Dec 22 1994 - 21:06:00 CET

This message: [ Message body ]
Next message: Mike Moritz: "HP/Oracle libXt.a, libX11.a ???"
Previous message: Shridhar Kamat [CONTRACTOR]: "Re: Oracle Forms 4.0 : Simple Question"
Next in thread: kenneth d atkins, s=david m thomas: "Re: Automatic handling of quotes in inesrt statement"
Reply: kenneth d atkins, s=david m thomas: "Re: Automatic handling of quotes in inesrt statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message