From oracle-l-bounce@freelists.org Mon Jan 24 19:09:23 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0P19NqW022229 for ; Mon, 24 Jan 2005 19:09:23 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0P19Mem022225 for ; Mon, 24 Jan 2005 19:09:22 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 65E0E63716; Mon, 24 Jan 2005 19:08:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30290-06; Mon, 24 Jan 2005 19:08:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D955A637C6; Mon, 24 Jan 2005 19:08:36 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: roger_xu@dp7uptx.com X-Msg-Ref: server-11.tower-65.messagelabs.com!1106608275!28844480!5 X-StarScan-Version: 5.4.5; banners=dp7uptx.com,-,- X-Originating-IP: [216.136.17.254] content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain X-MIMEOLE: Produced By Microsoft Exchange V6.0.6603.0 Subject: How does one escape special characters Date: Mon, 24 Jan 2005 17:11:01 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How does one escape special characters Thread-Index: AcUCafiNcbTBKcJWQPOYWr25o8l1+g== From: "Roger Xu" To: "Oracle-L@Freelists. Org (E-mail)" Content-Transfer-Encoding: 8bit X-archive-position: 15214 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: roger_xu@dp7uptx.com Precedence: normal Reply-To: roger_xu@dp7uptx.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=EXCUSE_16 autolearn=no version=2.60 X-Spam-Level: Hello list, I would use the following SQL to search for someone whose last name is O'REAR in sqlplus. SELECT * FROM emp WHERE name LIKE '% O/'REAR' ESCAPE '/'; How do I do it if I want to build the SQL first in a variable for a PL/SQL statement? cmd:='SELECT' || l_column || 'FROM emp WHERE name LIKE '% O/'REAR' ESCAPE '/'; --This gives me an error. Thanks, Roger This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@dp7uptx.com. -- http://www.freelists.org/webpage/oracle-l