write the Sql query for creating database backup?

Answer Posted / manojbatra071

create table backuptablename as select * from originaltablename;

Is This Answer Correct ?    3 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is not null in sql?

537


What is the usage of nvl function?

563


How do I view a table in sql?

523


Can we insert in view in sql?

543


What is pl sql quora?

616






what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

468


Is and as keyword in pl sql?

493


What is the primary key?

516


How to call shell script from pl sql procedure?

600


how can I make a script that can be bi-language (supports english, german)? : Sql dba

515


What are the features of pl sql?

533


Explain unique key in sql.

536


what are ddl statements in mysql? : Sql dba

554


What is the difference between a query and a report?

493


What is serial sql?

501