create table backup as select * from user_tables; create table backup1 a

write the Sql query for creating database backup?

Question Posted / ganesh

Answer Posted / ganesh

create table backup as select * from user_tables;

create table backup1 as select * from user_source;

Is This Answer Correct ?

4 Yes

13 No

Please Help Members By Posting Answers For Below Questions

How insert into statements in sql?

598

When you have to use a default "rollback to" savepoint of plvlog?

736

What is localdb mssqllocaldb?

631

What are the operators used in select statements?

582

what is collation? : Sql dba

626

What is set transaction?

594

What is scalar data type in pl sql?

569

What is the purpose of normalization?

547

what is the difference between blob and text? : Sql dba

538

What is mutating table error?

674

How much ram can sql express use?

517

Is there a 64 bit version of ssms?

527

What view means?

566

What is sql and its types?

632

explain advantages of innodb over myisam. : Sql dba

656