A really ugly way is always to do the
 
    Insert into table MyData values (first_value, second_value, 'A&'||'M University');
 
Its worked in SQLPlus doing that by hand ..... but its ugly.  Gotta be a beter way.
-----Original Message-----
From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject: How to deal with special character like & in ' '

Hi,

I want to insert a string like 'A&M University' but has problem with '&'   I want the database exact A&M University. But it always ask me new or old value because of symbol '&' how could I deal with that. Thanks.

HL



Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Reply via email to