Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Synonym for built-in function

894282Oct 13 2011 — edited Oct 13 2011
Is there any possiblity to create synonym to build-in function in Oracle database ?

ex. create public synonym p_util.trim for trim


I need it because I rewrite application to work both with Oracle DB and SQL Server. I wrote counterparts for Oracle functions like trim or to_date.
When I use it in SQL Server, I always must use schema prefix . To unify statement form i want to use schema prefix in Oracle too.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2011
Added on Oct 13 2011
3 comments
529 views