Rename a Table in Oracle Example

How to Rename Table in Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to rename a table in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR
   -- Syntax : RENAME old_table_name TO new_table_name

   RENAME COPY_REGIONS TO REGIONS_BAK;
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How to Rename Table in Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..