Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Question

Re: SQL Question

From: Alex Shnir <shnira_at_staff.juno.com>
Date: Thu, 08 Jul 1999 15:10:41 -0400
Message-ID: <3784F7B1.42FD324E@staff.juno.com>


removal of order by clause will fix it

Mark Wagner wrote:

> This is the insert im trying to do: (PAYROLL_WITH_NO_CUSTOMERIDS is a view)
>
> INSERT INTO DEDUCTEES ( FName, LName, EmployeeID )
> SELECT FName, LName, EmployeeID
> FROM PAYROLL_WITH_NO_CUSTOMERIDS
> GROUP BY FName, LName, EmployeeID
> ORDER BY LName;
>
> this is the response i get:
>
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
> SQLWKS> INSERT INTO DEDUCTEES ( FName, LName, EmployeeID )
> 2> SELECT FName, LName, EmployeeID
> 3> FROM PAYROLL_WITH_NO_CUSTOMERIDS
> 4> GROUP BY FName, LName, EmployeeID
> 5> ORDER BY LName;
> ORDER BY LName
> *
> ORA-00933: SQL command not properly ended
>
> Im not sure what is wrong.......
>
> thanks
>
> Mark
> mark_at_cybertrails.com
Received on Thu Jul 08 1999 - 14:10:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US