I needed to add to the above that the query should only update records so that it leaves at least one of them as true (the 't' value) if TABLE_B.LIFECYCLE_STATUS is NOT 'RETIRED'.
Also the last few lines should have been as follows... AND TABLE_A.TYPE = 'database' AND TABLE_B.TYPE = 'SERVICE-DATABASE' AND TABLE_B.ACTIVE = 't' AND TABLE_A.BC_LIFECYCLE_STATUS = 'RETIRED' OR COUNT( TABLE_B.RELATIONSHIP_NAME ) > 1) Nevertheless above is just an example of the type of a problem that I need to solve. So I am more interested about the methodology (if any exists) or the thinking process used when building these queries to solve these types of problems. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
