Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: For frequently changing table name and column name?..!!
Why don't you just (re-)create a View that 'maps' the new/different Table
and Columns names into the 'standard' ones used by the application?
Example:
Create View STANDARD_NAME
As
Select NEW_COLUMN1 As STANDARD_COLUMN1,
NEW_COLUMN2 As STANDARD_COLUMN2, NEW_COLUMN3 As STANDARD_COLUMN3Received on Fri Nov 03 2000 - 05:57:06 CST