Re: problem with wildcards . Help!!!
Date: 20 Jun 2002 19:34:53 -0700
Message-ID: <c2d690f2.0206201834.4e319d87_at_posting.google.com>
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?
> Thank you.
& is an oracle keyword for user prompts and it is unforgiving even
when enclosed within ''. You can escape this by using ascii equivalent
of & which is 38. so changing,
'http://finance.yahoo.com/d/quotes.csv?format=sl&ext=.csv&symbols='
to
'http://finance.yahoo.com/d/quotes.csv?format=sl'||CHR(38)||'ext=.csv'||CHR(38)||'symbols='
can work. However, you might want to be on gaurd for data integrity
due to &'s floating around in your data.
HTH Received on Fri Jun 21 2002 - 04:34:53 CEST