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

Can we use pl sql in sql server?

1075

How do you update a sql procedure?

1019

give the syntax of grant and revoke commands? : Sql dba

1145

Why having clause is used in sql?

969

What is the use of nvl function?

1179

Does truncate release storage space?

1065

Can we call a function containing dml statements in a select query?

966

What is insert command in sql?

1117

what is cursor. write example of it. What are the attributes of cursor.

1372

How delete all records from table in sql?

972

What is sql select statement?

1024

What is the file extension for sql database?

992

What is a composite primary key?

1081

How many types of cursors are available in pl/sql?

1097

Name the operator which is used in the query for pattern matching?

934