Re: problem with wildcards . Help!!!

mednyk_at_hotmail.com (inna) wrote in message news:<347a408b.0206210540.5f3aee32_at_posting.google.com>...
> Hello all. I tried to update table with string:
> update ttax set EXCHANGEUPDATEURL =
> 'http://finance.yahoo.com/d/quotes.csv?format=sl&ext=.csv&symbols=';
> and it gives me :
> "old 1: update ttax set EXCHANGEUPDATEURL =
> 'http://finance.yahoo.com/d/quotes.csv?format=sl&ext=.csv&symbols='
> new 1: update ttax set EXCHANGEUPDATEURL =
> 'http://finance.yahoo.com/d/quotes.csv?format=slcommit;=.csvOEM_sqlplus_input_finished='"
> I understand that the "&" causing it, but how can I insert this string
> into table? How can I escape this character?
>
>
>
> Thank you.

I don't know if you read mine or D.Y's previous posts. You need to replace the '&' with CHR(38) or If using SQL*Plus, set escape on and replace '&' with '\&'. Received on Sat Jun 22 2002 - 07:11:23 CEST