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

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 - 11:40:12 CDT