Generated Field vs Field plus Trigger
Posted by: Allen Farenhem
Date: August 08, 2018 02:03PM

I have a table on which I am using several generated fields. These fields are all computed from fields within the same record and are all stored fields (not virtual). The generated fields are used for dashboard / statistical measures.

I am now wondering as a best practice is the use of a generated field prefered over a static field updated by a insert / update trigger on the field they are dependent upon.

Any thoughts, insights or opinions would be much appreciated,


Options: ReplyQuote

Written By
Generated Field vs Field plus Trigger
August 08, 2018 02:03PM

Sorry, only registered users may post in this forum.

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.