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

What is trigger in flip flop?

518

What is sql table?

522

Which data type is a composite type?

532

What is sql keyword?

563

What are the features of pl sql?

563

Why is nosql good?

595

How many types of triggers are there in pl sql?

574

What is varchar sql?

620

Can I join the same table twice?

526

What are different types of queries in sql?

525

How does cross join work in sql?

535

What are sql functions? Describe in brief different types of sql functions?

488

Can %notfound return null after a fetch?

591

What is the syntax to add a record to a table?

577

what is index? : Sql dba

558