Re: problem with wildcards . Help!!!

mednyk_at_hotmail.com (inna) wrote in message news:<347a408b.0206201049.62cbbda2_at_posting.google.com>...
> I am trying to update table with value
> 'http://finance.yahoo.com/d/quotes.csv?format=sl&ext=.csv&symbols='
> but instead of this value I get
> 'http://finance.yahoo.com/d/quotes.csv?format=slcommit;=.csvOEM_sqlplus_input_finished='
> I know that '..sl&ext...' doesn't go trough because of '&' how can I
> escape this?

Assuming you use sqlplus, the default escape character is '\'. So try this,

SQL> set escape on
SQL> update ... set <column_name>=
SQL> 'http://finance.yahoo.com/d/quotes.csv?format=sl\&ext=.csv\&symbols='

> Thank you.
Received on Fri Jun 21 2002 - 07:11:02 CEST