A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between
Any event that makes a different record in the master block the current record is a coordination causing event.
There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete detail records.
There are three most common types of complex master-detail relationships:master with dependent detailsmaster with independent detailsdetail with two masters
Cascade Isolate Non-isolate
What are the different default triggers created when Master Deletes Property is set to Non-isolated?
Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details
Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete
Master Deletes Property Resulting Triggers ---------------------------------------------------Isolated On-Clear-Details On-Populate-Details
Latest Answer : On_clear_details -form level-> calls Clear_All_Master_Details proc.on_populate_details block level->calls Query_Master_Details proc. after checking foriegn key of null value. ...
The coordination properties are Deferred Auto-Query These Properties determine when the population phase of blockcoordination should occur.
Latest Answer : ImmediateDifferred->Yes Autoquery->YesDifferred->Yes Autoquery->No ...
