Re: ORA-00928: missing SELECT keyword

From: <fitzjarrell_at_cox.net>
Date: 15 Mar 2005 05:07:51 -0800
Message-ID: <1110892071.840474.12960@g14g2000cwa.googlegroups.com>

Frank van Bortel wrote:
> Anas wrote:
> > Hi ,
> > I have two schemas for development and testing. Both were populated
> > via import from another server.
> > I am getting "ORA-00928: missing SELECT keyword" error while I try
to
> > execute a query on one schema but it works fine with the other.
> > To resolve this I deleted all the existing statitics for indexes
and
> > tables, rebuilt all the indexes and collected new statistics using
> > DBMS_STATS.
> >
> > My server version is:
> > Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> >
> > Please help
> >
> > Thanks
> > Anas
>
> Yes - in line 23, you missed a '''
>
> --
> Regards,
> Frank van Bortel

You're either seeing something I don't see, Frank, or being ridiculously facetious.

Without the query you're trying to run it's impossible to tell WHAT is wrong. Please post the working and non-working queries so we can help you. None of us are psychic.

David Fitzjarrell Received on Tue Mar 15 2005 - 07:07:51 CST