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

Mention what is the use of function "module procedure" in pl/sql?

553

Does access use sql?

551

What is rownum?

529

what is a relationship and what are they? : Sql dba

544

What is on delete set null?

557

How do you remove duplicates without using distinct in sql?

494

Which are sql * plus commands?

531

Can ddl statements be used in pl/sql?

588

What is an inconsistent dependency?

569

What is trigger in sql? Explain

525

What is the best free sql database?

554

What is sql*loader and what is it used for? : aql loader

609

Can a trigger call a stored procedure?

526

Is pl sql a scripting language?

575

What are triggers and its uses?

585