How to change the oracle table name

Two ways to rename Oracle table names: Use SQL statements: ALTER TABLE RENAME TO ; Use PL/SQL statements: EXECUTE IMMEDIATE 'ALTER TABLE ' || :old_table_name || ' RENAME TO ' || :new_table_name;

How to rename Oracle table names

Method 1: Use SQL statements

 <code class="sql">ALTER TABLE  RENAME TO ;</code>

Method 2: Use PL/SQL statements

 <code class="sql">BEGIN EXECUTE IMMEDIATE 'ALTER TABLE ' || :old_table_name || ' RENAME TO ' || :new_table_name; END;</code>

Example:

 <code class="sql">ALTER TABLE employee RENAME TO staff;</code>

Notes:

• After renaming the table, all related objects such as constraints, indexes, triggers, and stored procedures will retain their original names.
• If the new table name already exists, Oracle throws an error.
• If the table name contains spaces or special characters, enclose the table name in quotes.
• After renaming the table, the reference to the old table name in the application or script will be invalid and needs to be updated accordingly.

The above is the detailed content of How to change the oracle table name. For more information, please follow other related articles on the PHP Chinese website!