1900 9:23:16 -0000
To: "LazyDBA Discussion" <[Email Address Removed] "akki " <oracledba-ezmlmshield-x55887219.[Email Address Removed] Thu, 17 Jun 2004 14:06:15 +0530
Subject: synonym for package.function_name()

hi all dba...
here is a query from my side

is there any way through which we can use single word instead of
using package_name.function_name in pl/sql or somewhere else...

can we create synonyms for functions for that purpose..........



SQL> select ex1.dow(sysdate) from dual;

EX1.DOW(SYSDATE)
----------------------------------------------------------------------------
----
Thu

SQL> create synonym dow for ex1.dow;

Synonym created.

SQL> select dow(sysdate) from dual;
select dow(sysdate) from dual
*
ERROR at line 1:
ORA-00904: "DOW": invalid identifier


thanks
akki


Oracle LazyDBA home page