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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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: [EMAIL PROTECTED] | |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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
