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: synonyms for table columns - are they possible?

Re: synonyms for table columns - are they possible?

From: Sheilah Scheurich <scheuric_at_sprynet.com>
Date: 1997/05/01
Message-ID: <3368ca4d.2125542@news.interserv.com>#1/1

On Mon, 28 Apr 1997 10:44:12 -0400, Allen Kirby <akirby_at_att.com> wrote:

>scheuric_at_wantnospam.com wrote:
>>
>> You can create synonyms. They are called aliases and are defined with
>> a create view command.
>>
>> -Sheilah Scheurich
>> DBA
>
>Actually synonyms, aliases and views are three different things.
>Synonyms are an alternate name for a table created with a create
>synonym command. A view is a view (look it up). And an alias is
>a way of identifying tables that appear twice in a select statement.
>--
>---
>Allen Kirby AT&T ITS Production Services
>akirby_at_att.com Alpharetta, GA.

Allen,
Thankyou for that differientiation. However, before publicly critiquing a colleague, please check what the original question was. I am very well aware that they are different things, however the question was is there a way to create synonyms for column tables. Therefore your response was not only embarrassing, it was incorrect.

sheilah Received on Thu May 01 1997 - 00:00:00 CDT

Original text of this message

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