Need one table with two names
I would like to add a second, alternate name to an existing table to facilitate migration issues.
For example, say I have a table called "zips". I now want to have this table also be called "postalcodes" and be able to select from this single table equally well by either name. The idea is that once all the code is changed from "zips" references to "postalcodes" references, the "zips" name can be retired. (Oh, it would be great to have a way to "see" which name is being used in database requests to double-check before the "retirement".)
I think this is clear. Ideally, the scheme would add the second name as a one-time database change rather than as something that needs to be set up each time the database is opened or the table is referenced, but I'll take what is available (duh).
Thanks
Subject
Written By
Posted
Need one table with two names
October 17, 2011 08:52AM
November 01, 2011 05:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.