Re: Renaming a function

From: Jens Lenge <spampot_at_gmx.net>
Date: 7 Feb 2007 03:40:03 -0800
Message-ID: <1170848403.225970.27740@s48g2000cws.googlegroups.com>

On 7 Feb., 12:35, "gazzag" <gar..._at_jamms.org> wrote:

> 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.

Ooops - I thought there was only one version of Oracle XE so far. Isn't it?
However, it is XE 10.2.0.1, and it is running on Windows XP SP2.

> 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.

Okay, that's a good way out if renaming is not available.

Thanks,
Jens Received on Wed Feb 07 2007 - 05:40:03 CST