Using "*" in Views

[haasi]

Hallo,

I would like to use "*" to select all columns of a table results in a column list in the view definition.

Example:
create view test_view as
select * from dual;

Result (from user_views):
select "DUMMY" from dual

Is there a way to keep the "*" in the view definition, so that new column in underlying views or tables automatically become part of the view?

For example: Can I add set a paramters or anything like that?

I need this behavior, so that individual views immediately show new columns in underlying views after these default views of a software package are changed as part of a software update.

best regards

 

[stefanz]

you cannot, according to: https://docs.oracle.com/database/121/SQLRF/statements_8004.htm#SQLRF01504

there it says:
If the subquery uses an asterisk (*) to select all columns of a table, and you later add new columns to the table, then the view will not contain those columns until you re-create the view by issuing a CREATE OR REPLACE VIEW statement.