Database Administrator (DBA) Question:
What are the two phases of block coordination?
Answer:
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. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated with the new master record. These operations are accomplished through the execution of triggers.
| Previous Question | Next Question |
| What is a timer? | What are Most Common types of Complex master-detail relationships? |