Weird, can someone explain as to why this happened ?

From: Arthur <mechhunter_at_rocketmail.com>
Date: Fri, 15 Sep 2000 08:25:43 GMT
Message-ID: <39c1dc40.5077877@news.iinet.net.au>

SQL> select * from emp_vu;

    empno Employee      Deptno
--------- 	  ---------- 	          ---------
     7369 SMITH             20
     7499 ALLEN             30
     7521 WARD              30
     7566 JONES             20
     7654 MARTIN            30
     7698 BLAKE             30
     7782 CLARK             10
     7788 SCOTT             20
     7839 KING              10
     7844 TURNER            30
     7876 ADAMS             20
     7900 JAMES             30
     7902 FORD              20
     7934 MILLER            10

14 rows selected.

After creating the view - I did a select via the view and this is the result.

SQL> select employee from emp_vu;
select employee from emp_vu

*
ERROR at line 1:
ORA-00904: invalid column name

I got fed up and recreate the view and this time, it worked. Why would the error occur in the first place ? I had everything correct, or so I hope - can someone shed some light into this please ?? So next time it happens, I will know why.

Arthur Received on Fri Sep 15 2000 - 03:25:43 CDT