sql - Impact: Delete a View, Create table with same name -

so there view in oracle named xyz , says, going replace table of same name.

what kind of impact can create existing sql's written on view? syntax querying view same table?

by "... replace table ..." assume mean table created same data view referencing. in other words, new table redundantly contains data other tables (those view referencing).

select-statements not need changed - syntax same.

but: view reflect changes in underlying tables. table not - have kept in sync triggers or application logic. depending on view, might rather big change. more if view updateable.

example:

suppose view defined ... select a.key, b.name a,b b.key = a.b_ref

then selecting view reflect changes tables a , b.

if replace table, have update new table every time update table a or b.