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

Home -> Community -> Usenet -> c.d.o.server -> Re: Synonyms for Table Columns - Are they possible?

Re: Synonyms for Table Columns - Are they possible?

From: David Ng <david_ng_at_mindlink.bc.ca>
Date: 1997/04/08
Message-ID: <334B2FFE.11A6@mindlink.bc.ca>#1/1

Nathan Secrist wrote:
>
> Hi All,
>
> We have created synonyms for a 100-table database
> that makes it easier for our users so they don't have
> to type such long table names (Ex: synonym for CUSTOMER_ORDER
> table is CO).
>
> My question: Is there a way in Oracle to create synonyms
> for column names similar to tables and views? Some of our
> column names are also very long and we would like to shorten
> them with synonyms as well (Ex: synonym for CUSTOMER_ORDER_NUM
> would be CON, etc.)
>
> Any help on this on whether or not it can be done would be
> greatly appreciated.
>
> Thanks in advance!
>
> Nathan
>
> Evolving Systems, Inc.
> nsecrist_at_evolving.com

May be you can use view to get around this.

For example,

Create view short_name(CO, CD)
for
select customer_order_id, customer_order_date from ver_long_table_name ; Received on Tue Apr 08 1997 - 00:00:00 CDT

Original text of this message

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