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!

How to rename multiple tables at Once?

792290Aug 23 2010 — edited Feb 29 2012

Hi,
I would like to know how to rename multiple tables in oracle at once? for example I have test, test_1, test_3 ETC... THE TABLES and I would like rename them with KC_test, KC_test_1, KC_test_3 etc....

how do I do them at once rather than doing them one by one....

Thank you.

This post has been answered by 672680 on Aug 23 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2012

Added on Aug 23 2010

#11g

7 comments

4,375 views