Re: Creating a view

From: Vern Reynolds <vernreynolds_at_yahoo.com>
Date: Mon, 24 Mar 2003 13:31:20 -0500
Message-ID: <M2Ifa.123777$334.77813_at_fe05.atl2.webusenet.com>

> > 3 where HYMNAL.PAGE=CHURCH.SCHEDULE.SSOPENINGHYMNNUMBER
> > 4 AND HYMNAL.PAGE=CHURCH.SCHEDULE.SSCLOSINGHYMNNUMBER
> > 5 AND HYMNAL.PAGE=CHURCH.SCHEDULE.WSOPENINGHYMNNUMBER
> > 6 AND HYMNAL.PAGE=CHURCH.SCHEDULE.WSCLOSINGHYMNNUMBER;
>
> --
> Regards, Frank van Bortel

Thanks Frank,

I made the adjustments and now I get the following. They are valid column names.

SQL> ed
Wrote file afiedt.buf

  1 create view vern (ssopen, ssclose, wsopen, wsclose)   2 as SELECT TITLE from HYMNAL, SCHEDULE   3 where HYMNAL.PAGE=CHURCH.SCHEDULE.SSOPENINGHYMNNUMBER

  4  and HYMNAL.PAGE=CHURCH.SCHEDULE.SSCLOSINGHYMNNUMBER
  5  and HYMNAL.PAGE=CHURCH.SCHEDULE.WSOPENINGHYMNNUMBER
  6* and HYMNAL.PAGE=CHURCH.SCHEDULE.WSCLOSINGHYMNNUMBER

SQL> /
and HYMNAL.PAGE=CHURCH.SCHEDULE.WSCLOSINGHYMNNUMBER

                                *

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

Regards,

Vern Received on Mon Mar 24 2003 - 19:31:20 CET