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