Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there something for a COLUMN like SYNONYM is for a TABLE?
Brian Tkatch wrote:
> 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.
Only with a view and the efficiency is something you need to test with your queries using your hardware with your application data. Likely it will be small enough to be ignored.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Oct 17 2007 - 14:47:56 CDT