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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there something for a COLUMN like SYNONYM is for a TABLE?

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 17 Oct 2007 12:47:56 -0700
Message-ID: <1192650466.247407@bubbleator.drizzle.com>


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.org
Received on Wed Oct 17 2007 - 14:47:56 CDT

Original text of this message

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