Re: Possible: View = "Select * ..." ?

I am not quite sure,
but as far as I know this is not possible since it would not be conform to SQL standards.

Stefan

Loy&Hutz wrote in message <01bde302$20763760$6d6464c3_at_kom>...
>Possible: View = "Select * ..." ?
>
>If I create a view in Oracle with definition "Create view as select * from
>Tab..."
>
>the view is defiened with all columns (select col1, col2... from Tab...)
>
>this is bad if I change the table definition.
>
>So, is it possible to define a view as "Select *"
>
>Any solution ?
>
>Thanks in advance
>
>Sven Kunze
>
Received on Fri Sep 18 1998 - 12:08:09 CDT