Re: alias for long object name

You can alias the object name in SQL statements. But not in PL/SQL code. Oracle's version of an alias for something other than right in the SQL statement is a synonym. Why not just create one?

Cheers,Brian

Christoph Seidel wrote:
>
> 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.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"