Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: INSERT INTO
On 7 Jun, 14:49, Wazusa Blong <fitzjarr..._at_cox.net> wrote:
> On Jun 7, 7:36 am, colmkav <colmj..._at_yahoo.co.uk> wrote:
>
> > Anyone know why this code gets an error "ORA-00911: invalid
> > character"?
>
> > INSERT INTO ta_tmp(description)
> > SELECT DISTINCT description
> > FROM t_exposuretype
> > WHERE description not in (select description from
> > ta_exposuretype);
>
> > The Select part works fine.
>
> Have you retyped the query? Don't 'copy and paste', take the time to
> actually retype the entire statement. You *may* have a 'hidden'
> control charcter somewhere causing your error.
>
> David Fitzjarrell
THANKS, yes that would seem to be the problem. Received on Thu Jun 07 2007 - 08:05:54 CDT