Re: Views (again) in 8.1.7

This indeed is strange. This is what I found.

SQL> select * from table1;

      COL1 COL2 COL3
---------- ---------- ----------

         1 1 1

SQL> create view v_tot as
  2 select col1, col2+col3 "tot" from table1;

View created.

SQL> select col1, tot from table1;
select col1, tot from table1

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

SQL> drop view v_tot;

View dropped.

SQL> create view v_tot as
  2 select col1, col2+col3 "TOT" from table1;

View created.

SQL> select col1, tot from v_tot;

      COL1 TOT
---------- ----------

         1 2

Regards
Bhooshan

"Maarten" <mmg_brouwers_at_hotmail.com> wrote in message news:<oPzE8.31715$48.2542923_at_zwoll1.home.nl>...
> Hi All,
>
> I looked in the archives but found no solution for my simple problem.
> I receive an error when I select the TOTAL column from my view.
> How can I resolve this???
>
> create view v_tot as select fld1,fld2+fld3 "tot" from table1;
>
> select fld1,tot from v_tot;
>
> the error is on: tot
>
> All help is greatly appreciated.
> Maarten
Received on Thu May 16 2002 - 10:32:50 CEST