newbie oracle question

From: Vic Smyth <vicsmyth_at_megsinet.net>
Date: Sun, 11 Apr 1999 16:42:07 -0700
Message-ID: <3711334F.6B91_at_megsinet.net>

Hi,

I'm doing a project for class using Oracle Sqlplus and am stuck on a problem. I've created a view and am trying to query the view but get an error message. Any help would be appreaciated!

Here's what I have, the error message is below.

Vic

To reply to email remove the "myth" from the address.

SQL> CREATE VIEW TEMPX AS
  2 SELECT INVOICE.CUS_CODE "C_Code", COUNT(DISTINCT INVOICE.INV_NUMBER)"Inv_Nu
m",
  3 SUM(LINE_UNITS*LINE_PRICE)"SumOfLine"   4 FROM INVOICE, LINE
  5 WHERE INVOICE.INV_NUMBER = LINE.INV_NUMBER   6 GROUP BY INVOICE.CUS_CODE; View created.

SQL> select * from tempx;

C_Cod Inv_Num SumOfLine
----- --------- ---------

10011         3       444
10012         1    153.85
10014         2    422.77
10015         1     34.97
10018         1     70.44

SQL> DESCRIBE TEMPX;
 Name                            Null?    Type
 ------------------------------- -------- ----
 C_Code                          NOT NULL CHAR(5)
 Inv_Num                                  NUMBER
 SumOfLine                                NUMBER

SQL> SELECT SUM(Inv_Num),SUM(SumOfLine),MIN(SumOfLine),   2 MAX(SumOfLine),AVG(SumOfLine)
  3 FROM TEMPX;
MAX(SumOfLine),AVG(SumOfLine)

                   *

ERROR at line 2:
ORA-00904: invalid column name

SQL> Received on Mon Apr 12 1999 - 01:42:07 CEST