RE: How to insert Special Characters ?

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