Is there something for a COLUMN like SYNONYM is for a TABLE?

Hello,

 i am working with Oracle 9i on a project where the TABLEs and COLUMNs conform to some standard, which, IMO, makes the names too tedious to use in ad hoc queries. To ease use, i CREATEd a SYNONYM for each TABLE, and i am happier with it now.

I would like to do the same thing to the COLUMN names (remove the project/table prefix, add in vowels, correct typos, etc...), but there are no SYNONYMs for COLUMN names. So, i was thinking of DROPping the SYNONYM idea, and just renaming both TABLEs and COLUMNs in a new VIEW for each TABLE.

I have two questions. One, will using a VIEW (straightforward select col_1, col_2, ..col_n from table) be inefficent, or is it the same as querying the TABLE directly? Two, is there something for a COLUMN like SYNONYM if for a TABLE?

B. Received on Wed Oct 17 2007 - 13:09:21 CDT