Re: Using AlphaNumeric Keys
Posted by:
Cat B
Date: January 31, 2019 12:03PM
Phillip Ward Wrote:
-------------------------------------------------------
> Correct. There is no Magic in any of this.
>
> If you change [the structure of] the
> underlying Table(s) then you ought to
> change [the structure of] the View as well!
> That is part of your job as Administrator
> of this Database.
>
> Of course, if the data in the underlying
> table changes, then your View - which is little
> more than Query with a Name - will show the
> updated data immediately.
>
> Regards, Phill W.
Okay, thank you for clarifying that!!
I will have to start taking advantage of Views moving forward, and that should all but eliminate my need to dabble with natural keys!
Subject
Written By
Posted
Re: Using AlphaNumeric Keys
January 31, 2019 12:03PM
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.