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

Explain what is dbms?

974

What is sql and db2?

938

How does index help in query performance?

964

How do you write a subquery?

960

What are the parts of a basic sql query?

916

what is sp_pkeys? : Transact sql

1098

Explain ttitle and btitle.

1056

What is a system versioned table?

927

What are different joins used in sql?

1007

What packages are available to pl/sql developers?

991

How do you define a foreign key?

937

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1155

how to get a list of indexes of an existing table? : Sql dba

913

Can we call dml statement in function?

975

What is data modelling in sql?

958