Re: Synonyms for Table Columns - Are they possible?

Why not create a single Table View for each of the Tables. In there you could redefine the column names. Then, point the synonyms for your table names to the views instead. Lot of work for very little gain though - being a miserable Oracle DBA I prefer to enforce my naming standards on Developers and if they don't like it.......!

In article <5ir7k2$lhu$6_at_tst.hk.super.net>, Michael Ho <"infoage_at_hk.super.net, hom"@clsasia.com> writes
>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.)
>
>Synonym for columns ? No.
 

-- 
Brian McCabe
McCabe IT Consulting Limited
brian_at_mitc.demon.co.uk