OraFAQ Forum: Client Tools » How can i escape & in a query

Home » Other » Client Tools » How can i escape & in a query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i escape & in a query [message #291411]

Fri, 04 January 2008 02:15

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 ?

Report message to a moderator

Re: How can i escape & in a query [message #291426 is a reply to message #291411]

Fri, 04 January 2008 03:07

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,

Report message to a moderator

Previous Topic:	Role of "/" and ";" in SQL file
Next Topic:	SQL worksheet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 09:41:07 CST 2025