Re: Weird, can someone explain as to why this happened ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Sep 2000 12:08:29 +0200
Message-ID: <969014377.23226.2.pluto.d4ee154e@news.demon.nl>

select "Employee" from emp_vu.
'Special' characters including lowercase should be enclosed in ". Evidently, you shouldn't use mixed case as it is a *real* nuisance to have to do this.

Hth,

Sybrand Bakker, Oracle DBA

"Arthur" <mechhunter_at_rocketmail.com> wrote in message news:39c1dc40.5077877_at_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 - 05:08:29 CDT