Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: For frequently changing table name and column name?..!!

Re: For frequently changing table name and column name?..!!

From: Mike & Martha <mmrose_at_home.com>
Date: Fri, 3 Nov 2000 06:57:06 -0500
Message-Id: <10669.121042@fatcity.com>


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_COLUMN3
Received on Fri Nov 03 2000 - 05:57:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US