ABSTRACT
Part of the task of enforcing naming standards can be reduced to a simple search and replace function, just as in a word processor. For example, we can look for all instances of the character string MODIFIED and replace them with MDFD. Or replace IDENTIFICATION with ID, PURCHASE with PURCH, and CUSTOMER with CUST. A column named CUSTOMER_IDENTIFICATION would then become CUST_ID. Unfortunately, there is no search and replace utility in Oracle Designer 2.1.2. This task can be done manually at the risk of inconsistencies and typing mistakes. In practice, it is seldom performed because it is extremely tedious; thus, volunteers are scarce because it requires maintenance when the data model changes and because it is too timeconsuming for tight project timescales. We will show how we can put a script together that will do this for us. This script issues a few calls to the Oracle Designer API. It can be run several times throughout the duration of the project.
