RE: How to deal with special character like & in ' '

2001-07-24 Thread Ramasamy, Baskar 

You could do select 'string1 '|| chr(38) ||' string2' from dual
 
Baskar

-Original Message-
Sent: 23 July 2001 18:51
To: Multiple recipients of list ORACLE-L



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/ 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramasamy, Baskar
  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).

Re: How to deal with special character like & in ' '

2001-07-23 Thread Saurabh Sharma 



choose use some other character for 
define. 
set define $ or so..
will let u insert string containing 
&
 
Saurabh Sharma
 
[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

  - Original Message - 
  From: 
  Kevin Lange 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, July 24, 2001 3:03 
AM
  Subject: RE: How to deal with special 
  character like & in ' '
  
  Thanks Joe.   I did 
  not know that command existed.    Makes life 
  easier.
  
-Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 
Monday, July 23, 2001 1:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: How to deal with special character like 
& in ' '
set scan off
 
joe
>>> [EMAIL PROTECTED] 07/23/01 01:51PM 
>>>
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! Messengerhttp://phonecard.yahoo.com/

RE: How to deal with special character like & in ' '

2001-07-23 Thread Kevin Lange 



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 
  PMTo: Multiple recipients of list ORACLE-LSubject: 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! Messengerhttp://phonecard.yahoo.com/

RE: How to deal with special character like & in ' '

2001-07-23 Thread Kevin Lange 



Thanks Joe.   I did 
not know that command existed.    Makes life 
easier.

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 23, 2001 1:49 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  How to deal with special character like & in ' '
  set scan off
   
  joe
  >>> [EMAIL PROTECTED] 07/23/01 01:51PM 
  >>>
  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! Messengerhttp://phonecard.yahoo.com/

RE: How to deal with special character like & in ' '

2001-07-23 Thread Yadav, Shailesh 

You can do either of the following:
SET SCAN OFF before the statement
if not possible then
you could do INSERT... ('A'||'&'||'M University')...;


-Original Message-
Sent: Monday, July 23, 2001 2:49 PM
To: Multiple recipients of list ORACLE-L


try inserting  ('A'||CHR(38)||'M University')

the CHR() is great for special characters.

-Original Message-
From:   Helen rwulfjeq [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 23, 2001 1: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/ << File: ATT00040.html >> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Rogge
  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: Yadav, Shailesh
  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).

Re: How to deal with special character like & in ' '

2001-07-23 Thread JRicard982 

Helen,

In SQL*Plus:

set escape on
insert into dept(dname)
values ('A\&M');

That should work.

Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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).

RE: How to deal with special character like & in ' '

2001-07-23 Thread William Rogge 

try inserting  ('A'||CHR(38)||'M University')

the CHR() is great for special characters.

-Original Message-
From:   Helen rwulfjeq [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, July 23, 2001 1: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/ << File: ATT00040.html >> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Rogge
  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).

Re: How to deal with special character like & in ' '

2001-07-23 Thread JOE TESTA 



set scan off
 
joe
>>> [EMAIL PROTECTED] 07/23/01 01:51PM 
>>>
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! Messengerhttp://phonecard.yahoo.com/

How to deal with special character like & in ' '

2001-07-23 Thread Helen rwulfjeq 
 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.
HLDo You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/