RE: How to insert Special Characters ?

1. Use Bind Variables, explicitly in your SQL statements would resolve this problem. This would enhance the perf. as there would be one time parsing and many time executions. Hard Parse can sometimes be more memory and CPU intensive rather than the execution time any SQL statement takes.
2. If not Interested in Bind Variables then, For single Quotation marks use Chr(39) || '1234' || Chr(39) in your SQL statement to solve the problem.

Vikas Khanna

-----Original Message-----
Sent: Wednesday, July 31, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L

i presume the statement is a string that u want to insert...

so u can write like this :
select
'where part_no = ''1234'' and name=''guest''' from dual;

check the quotes out....

rgds,
Ams,
www.medicomsoft.com

|-----Original Message-----
|From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of guess who
|Sent: Wednesday, July 31, 2002 8:58 AM
|To: Multiple recipients of list ORACLE-L
|Subject: How to insert Special Characters ?
|
|
|I want to insert the following characters ,
|
|1.) '
|
|2.) "
|
|3.) &
|
|for example i want to insert the following line as it looks...
|
| where part_no='1234' and name='guest'
|
|how to do ?
|
|can anyone help ...
|
|Regards,
|Prakash.
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: guess who
| INET: yours_in_at_rediffmail.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).
|
|

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Amjad Saiyed
  INET: amjad_at_medicomsoft.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vikas Khanna
  INET: vkhanna_at_quark.co.in

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).