Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: synonyms for table columns - are they possible?
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