Table Backup in SQL

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