Re: alias for long object name

Hi "Tanel Poder" <tanel@@peldik.com>, thanks for writing this:
> a view?
>
> Tanel.
>
> "Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote in message
> news:bfrjnr$hua26$1_at_ID-143718.news.uni-berlin.de...
> > Hi,
> >
> > is it possible to use an alias for an object name like
> schema.table_at_linkname
> > without creating a synomym? I have a stored proc which references this
> long
> > name very offen and i do not want to type it again and again.
> >
>

While I have nothing against using a view, it might cause a minor problem (if such a strong word as "problem" is appropriate) in this particular case.

If I add a column to the table (or drop a column), I have to remember to update the view as well (unless it's simply select *). Of course, I might also need to update the stored procedure. The more "objects" I have to change the more chance I have to make a typo.

Using a synonym doesn't have this problem. It will always get the current description of the table from the data dictionary.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]