Oct 3, 2012

How to Alter a Table in Oracle.

We can do the alteration of the table using command called Alter.
Syntax:
Alter Table [Table Name] Rename To [New Table Name]
Eg:
Alter Table Book Rename To Store_Books;
alter table Emp rename to tbl_Emp;