Views question

From: Fayerman <ilya_at_fayerman.org>
Date: Wed, 15 Aug 2001 14:21:33 GMT
Message-ID: <Nzve7.72$rw3.45656@dfiatx1-snr1.gtei.net>

Hi,

I have a simple question about views.

create view test
as
select * from [some_table]
where [some_condition]

The view is created. However, the problem is that the view is not dynamic, you can tell that by looking at the user_views table, text column. It references all actual columns in [some_table], which means if [some_table] gets expanded, the view will become invalid.

How can I create a view that will select all, but not actual columns?

Thank you Received on Wed Aug 15 2001 - 09:21:33 CDT