RE: Special characters once again !

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Thu, 01 Aug 2002 08:23:26 -0800
Message-ID: <F001.004A8E64.20020801082326@fatcity.com>

Use concatenation and the CHR function (39 = ') to insert your string.

  1 insert into tableA (columnA)
  2* values ('where part_no='||chr(39)||'1234'||chr(39)||' and name='||chr(39)||'guest'||chr(39))
SQL> / 1 row created.

SQL> select * from tableA;

COLUMNA

---

---

where part_no='1234' and name='guest'

-----Original Message-----
Sent: Thursday, August 01, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L

I told that i want to insert the following.... where part_no='1234' and name='guest'

but i tried as u people said ( ' Where part_no="1234" and name="guest" ' ) but the result was, which is as follows.... where part_no="1234" and name="guest"
but what i need is as follows...
where part_no='1234' and name='guest'
Regards,
Prakash.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Fink, Dan
  INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 01 2002 - 11:23:26 CDT