You can create table backups by using below commands.
In MS SQL
SELECT * INTO <backup_table_name> FROM <original_table_name>
Ex:
SELECT * INTO FUEL_DETAILS_BACK FROM FUEL_DETAILS
In Oracle
CREATE TABLE
<backup_table_name> AS SELECT * FROM <original_table_name>
Ex:
CREATE TABLE HR_LEAVE_ENTITLE2011 AS
SELECT * FROM HR_LEAVE_ENTITLE
No comments:
Post a Comment