Home » SQL & PL/SQL » Client Tools » How can i escape & in a query
How can i escape & in a query [message #291411] Fri, 04 January 2008 02:15 Go to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
Hi ................

i just created a table

create table test1(col_1 char(50)) ;

i was ok .............

then i tried to insert a string like 'me & my brother' to the table
insert into test1 values(me & my brother');

then i got a message
Enter value for my:
i just pressed the enter key , then insert was completed.

then i selected the value ,

i got the value as "me brother"

then i tried to insert a string like 'me \& my brother' to the table
then i got same as above

then i tried to insert a string like 'me &} my brother' to the table
then i got the result as 'me &} my brother'


But i want to get the result as 'me & my brother'

it is a crucial situation because i am doing migration of MSSQL data to Oracle 10g
can u help me ?
Re: How can i escape & in a query [message #291426 is a reply to message #291411] Fri, 04 January 2008 03:07 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
this question has been asked and answered many times in this forum.search for escape characters


regards,
Previous Topic: Role of "/" and ";" in SQL file
Next Topic: SQL worksheet
Goto Forum:
  


Current Time: Thu Dec 08 00:11:36 CST 2016

Total time taken to generate the page: 0.20014 seconds