Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Renaming a function

Re: Renaming a function

From: gazzag <gareth_at_jamms.org>
Date: 7 Feb 2007 03:35:19 -0800
Message-ID: <1170848119.433091.90590@a34g2000cwb.googlegroups.com>


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

Original text of this message

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