Re: Creating a view
From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 24 Mar 2003 20:03:06 +0100
Message-ID: <3E7F566A.8010209_at_netscape.net>
>
>
>
> 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
>
>
>
Date: Mon, 24 Mar 2003 20:03:06 +0100
Message-ID: <3E7F566A.8010209_at_netscape.net>
Vern Reynolds wrote:
>> > 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
>
>
>