Database Utilities

**1. ** **Improve the drop utility to establish proper order of dropping (FK constraints) objects. Meaning, the objects without dependencies should be dropped first** **2. ** **Improve the drop utility to allow dropping by object_name or object_type like “procedure?? using wild cards. This is in addition to existing functionality, not in replacement of such. One should be able to indicate (using wild cards) what object_types are desired to drop and, then, select (using wild cards) the particular objects. It is possible though that you have a better idea how to do it, do you?** **3. ** **Fix the Rows utility to insure that it handles improper object naming conventions stored in the Data Dictionary** **4. ** **Rewrite [login to view URL] utility to return to the environment that invoked initial/[login to view URL] utilities pair. Currently [login to view URL] returns you to the environment that was established at the beginning of the SQL*Plus session and not to the [modified] environment that invoked the intial/[login to view URL] utilities pair** **5. ** **Develop a new utility to display all primary and foreign key constraints for specified patterns of table names (with appropriate details, like column names)** **6. ** **Develop a new utility to display all constraints (with appropriate details, like column names) for specified patterns of table names** **7. ** **Make a proposal to create a new utility and, with instructor’s approval, implement it** ## Deliverables Make sure you properly package your utility submissions and provide proper instructions for installing your utilities Ensure that the only messages printed while executing your utility are your own (intelligent) messages and not Oracle error messages All of these tasks should be done using the same style as in existing utilities (exceptions may be allowed) ## Platform ORACLE