Re: errr, umm, variables in inserts, possible, help? :)

"Mike Williams" <news_at_mike-williams.co.uk> wrote in message news:se5r5u4ou54kh6hqnac4uhsq4pl6fjmdub_at_4ax.com...
> Hey all,
>
> I don't quite know how to explain the problem I'm having, mainly
> because I don't understand the problem, or even the point of what
> Oracle is doing.
> Due to a skirmish with Oracle before I got made redundant, and the
> boredom of unemployment, I've recently taken to learning something
> about Oracle.
>
> Anyway, the webhosting company I part run, log apache directly to
> MySql, a perfect source for an ass load of SQL data.
> The Oracle Migration Tool crashes, something to do with mm-mysql, I
> hate Java :)
> As the data isn't using any non Oracle standard (will that comment get
> me flamed? :P) I figured I could just @<file> import it from sqlplus
> (nice spamy way to do it, I know, after learning the hard way).
>
> Right, down to business.
> Most of it works fine, until it comes along a record with = signs in a
> varchar2.
> Then I get something like below...
>
> ---
> Enter value for hl:
> Enter value for start:
> Enter value for sa:
>
> old 1: INSERT INTO logs_12 VALUES (15092, 7, 32, 48, 1, 12, 2001,
> 'www.14-condoms.co.uk', 'pinky.notnet.co', '172.186.167.179', 'GET',
> NULL, '/board.html', 200, 21344, '',
>

'http://www.google.com/search?q=durex+condoms+and+advertising&hl=en&start=10 &sa=N',
> NULL, 'Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)', 2, 0, 0, 0, 0)
>
> new 1: INSERT INTO logs_12 VALUES (15092, 7, 32, 48, 1, 12, 2001,
> 'www.14-condoms.co.uk', 'pinky.notnet.co', '172.186.167.179', 'GET',
> NULL, '/board.html', 200, 21344, '',
> 'http://www.google.com/search?q=durex+condoms+and+advertising=en=10=N',
> NULL, 'Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)', 2, 0, 0, 0, 0)
> ---
>
> umm, why?
> The field is quoted, so why is it doing that?
> Does a & denote a variable of some kind?
>
> Can anyone shed any light, and offer a solutions?
>
> Cheers
> Mike Williams
> notnet Webhosting
> http://www.notnet.co.uk

the & does denote the start of a variable. You can change it by set define <any character you don't use> or set define off
The latter option will disallow the use of defines. The define command is a sql*plus command, described in the sql*plus reference manual.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address