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/