Re: ' in query

From: Cliff Buetikofer <clifford_buetikofer_at_merck.com>
Date: Tue, 16 Nov 1999 09:46:49 -0500
Message-ID: <38316E59.5C3BEA02@merck.com>

Review the following. It may be kind of ugly but it works.

SQL> select * from test;

QUERY

---

SELECT * FROM TABLE WHERE NAME ='A'   1 SELECT * FROM TEST
  2* WHERE QUERY='SELECT * FROM TABLE WHERE NAME ='||''''||'A'||'''' QUERY

---

SELECT * FROM TABLE WHERE NAME ='A'

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.

Received on Tue Nov 16 1999 - 08:46:49 CST