5-2. Keeping Related Values in Sync
Problem
You want to keep related values in sync that happen to be stored in separate tables. For example, say you are updating the salary level for a number of jobs within the JOBS table. However, in doing so, you will need to update the salaries within the EMPLOYEES table for employees having those jobs. In short, if you update the salary range for a job, then you want to automatically update salaries to ensure that they fall within the new range.
Note When we use the term related in this problem description, we do not necessarily mean related in the relational sense that one commonly thinks about. There is ...
Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
