Re: Using AlphaNumeric Keys
> According to the link you porvided, if I changed the uderlying table
> (e.g. dropped a column) then the View does NOT get updated.
Obviously, just as an sproc or an input form depends on table and column references inside it.
Remember, SQL is not a complete computer language. It's just a scripting language for translating relational algebra into human-readable words and back again. Except in "select * ...", it does not generalise much across identifiers.
> Any suggestions on getting the greatest benefits from Views
> without having a false sense of security?
Best solution for that I know is to follow best known practices, hope for the best, prepare for the worst.
Subject
Written By
Posted
Re: Using AlphaNumeric Keys
January 30, 2019 02:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.