Fish out of water (SQL Script error)
Date: Sat, 2 Jun 2001 10:03:45 -0700
Message-ID: <3b190ea5$0$766$e2e8da3_at_nntp.cts.com>
Hi,
I'm practicing for the first test, SQL, and I have come up to an error
in running this simple query. I don't believe that I am missing and
expression as Oracle suggests. However, there may be and expression
used in older versions that could be used to bypass the problem. Or,
the course work I've taken may have left an expression out. Could some
one help me in determining why the query returns an ORA-00936 error code?
Thanks in advance,
SQL> SELECT e.employee_name,
SQL*Plus: Release 8.1.7.0.0 - Production on Sat Jun 2 09:47:07 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
2 p.project_name,
3 FROM employee e,
4 project p,
5 project_hours ph
6 WHERE e.employee_id = ph.employee_id
7 AND p.project_id = ph.project_id
8 GROUP BY e.employee_id, e.employee_name,
9 p.project_id, p.project_name;
FROM employee e,
*
ERROR at line 3: ORA-00936: missing expression
JServer Release 8.1.7.0.0 - Production
Received on Sat Jun 02 2001 - 19:03:45 CEST