Re: CREATE VIEW fails, but works as just a SELECT
I know there are duplicate/redundant columns, but my question in why does it work and automatically remove the duplicate columns when the exact same statement is done without the 'CREATE VIEW AS' part in front on it? I thought that creating a view essentially is just like making a macro, so the fact that the statement is contained in a view or typed directly just as a SELECT shouldn't make a difference?
Subject
Written By
Posted
November 01, 2006 03:20AM
November 01, 2006 08:59AM
Re: CREATE VIEW fails, but works as just a SELECT
November 01, 2006 06:40PM
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.