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: Allen Kirby <akirby_at_att.com>
Date: 1997/04/28
Message-ID: <3364B7BC.31B6@att.com>#1/1

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.
Received on Mon Apr 28 1997 - 00:00:00 CDT

Original text of this message

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