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 are the different types of a subquery?

1048

What are conditional predicates?

1060

What is vector point function?

1052

what is the syntax for using sql_variant_property? : Transact sql

1044

Can we create view in stored procedure?

970

What is the trigger in sql?

953

How can I get the number of records affected by a stored procedure?

1065

What is full join in sql?

991

What are the operators used in select statements?

1058

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

1192

How does a self join work?

1125

What is the process of copying data from table a to table b?

1091

What is a pdo connection?

1042

How do I partition a table in sql?

1130

Can I learn sql in a week?

1073