Re: Views (again) in 8.1.7
Date: 15 May 2002 22:01:03 -0700
Message-ID: <eeb709c8.0205152101.60ae61bc_at_posting.google.com>
"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
Your tot field is using lower-case. In Oracle, field names are
uppercase. You can query
SELECT fld1, "tot" from v_tot;
to get your output.
Alternatively, change your create view statement to
create view v_tot as select fld1,fld2+fld3 "TOT" from table1;
Ali Received on Thu May 16 2002 - 07:01:03 CEST