Change in a Common Name

Occasionally a Common Name (such as Boeing) is entered incorrectly.  The user may change it providing no aircraft have been assigned that common name.  If the user (even a System ADMIN) tries to change it while it has an aircraft, the user will receive the following error message:

Open

SELECT ROWID, COMMON_NAME_CODE, COMMON_NAME, EFFECTIVE_DATE, ACTIVE_FLAG, MODIFIED_BY, MODIFIED_DATE
FROM CARS_AIRCRAFT_COMMON_NAME
WHERE INSTR(UPPER(COMMON_NAME), '@@@@') > 0 ;

‘@@@@’ is the Common Name to be changed

Change the COMMON_NAME column to the required new name