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: alias for long object name

Re: alias for long object name

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Fri, 25 Jul 2003 17:53:29 GMT
Message-ID: <MPG.198b0e75326ceca98980a@news.la.sbcglobal.net>


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]
Received on Fri Jul 25 2003 - 12:53:29 CDT

Original text of this message

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