Re: Views question

On Wed, 15 Aug 2001 14:21:33 GMT, "Fayerman" <ilya_at_fayerman.org> wrote:

>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
>

By replacing the * with the current column names. That's just the way it works, as views are compiled Please check your Oracle Concepts Manual on this issue

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Aug 15 2001 - 14:23:33 CDT