Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Renaming a function
On 7 Feb, 09:35, "Jens Lenge" <spam..._at_gmx.net> wrote:
> Hello world,
>
> I am pretty sure this is a simple-and-dumb question, yet still I did
> not find a solution with aunt Google or the Tahiti manuals. I would
> like to rename an existing function in an Oracle XE database with an
> SQL command (something like "alter function OldName rename to
> NewName", which does not work).
>
> What is the correct syntax to rename a function?
>
> (And what the heck are suitable search keywords to find this? I tried
> several combinations of "oracle", "sql", "rename", and "function".)
>
> Jens
A tip for future postings: please always mention what version of Oracle (e.g. Oracle 10g 10.2.0.1.0) and Operating System details.
Anyway, I dno't believe that functions can be renamed. Extract the DDL for the function, edit this to recreate the function with its new name and drop the original.
HTH -g Received on Wed Feb 07 2007 - 05:35:19 CST