如何重命名Oracle过程 [英] How to rename an Oracle procedure

问题描述

是否有一种方法可以重命名oracle过程，而不必删除并重新创建该过程?

Is there a way to rename an oracle procedure, without having to drop and recreate the procedure?

推荐答案

不幸的是，对于PL/SQL对象，没有ALTER TABLE ... RENAME TO的等效项.因此，恐怕您将不得不删除该过程并使用新名称重新创建它....

UNfortunately there is no equivalent of ALTER TABLE ... RENAME TO for PL/SQL objects. So I'm afraid you will have to drop the procedure and create it afresh with the new name....

...除非使用SYNONYM将解决您的绑定.不知道为什么，您想更改过程名称，这很难为您提供建议.

... unless using a SYNONYM will resolve your bind. Without knowing why you want to change the procedure name it's a bit difficult to give advice.

这篇关于如何重命名Oracle过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！