Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle error for sequence
Post the Nasty Nasty SQL please .
"Sergey Adamenko" <asv_n_o__s_p_a_m_at_softline.kiev.ua> wrote in message
news:3ec4a571$1_at_ns...
>
> "Mohammad" <mhakimjavadi_at_hotmail.com> wrote in message
news:cc59b627.0305151150.11c35b3_at_posting.google.com...
> > Hi
> >
> > I'm spooling data to a file and using a sequence number generator to
number
> > each record and I get an ORA-02287 error. When I look up the error, it
> > tells me this:
> >
> > ERROR at line 17:
> > ORA-02287: sequence number not allowed here
> >
>
> Sequence number not allowed in SELECT-s with GROUP BY, ORDER BY, UNION
clauses.
>
> Sergey Adamenko
>
>
>
>
Received on Fri May 16 2003 - 04:07:41 CDT