Re: CREATE VIEW fails, but works as just a SELECT
Posted by:
Bob Field
Date: November 01, 2006 07:03PM
The SELECT statement retains the duplicate columns as far as I am aware. It is generally considered poor coding practice to use the '*' notation, as changes to the underlying tables can break code relying on such queries. A view is not simply a macro but must be able to derive a column list and store this information statically just as if it was a real table. A view collects information dynamically but stores static schema information.
Subject
Written By
Posted
November 01, 2006 03:20AM
November 01, 2006 08:59AM
November 01, 2006 06:40PM
Re: CREATE VIEW fails, but works as just a SELECT
November 01, 2006 07:03PM
November 01, 2006 08:10PM
November 01, 2006 08:32PM
November 01, 2006 10:18PM
November 08, 2006 05:14PM
November 16, 2006 09:18AM
November 16, 2006 09:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.