SELECT column_name(s) INTO new_table_name FROM old

write the Sql query for creating database backup?

Question Posted / vikneswaran

Answer Posted / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How can you load microsoft excel data into oracle? : aql loader

1132

Will truncate release space?

900

Can we use ddl statements in stored procedure sql server?

970

What is the default isolation level in sql server? : Transact sql

975

What are the two types of periodical indexes?

893

How can you fetch first 5 characters of the string?

958

What is pivot in sql?

879

How do I add a primary key to a table?

980

What is before and after trigger?

901

What is a primary key? Explain

925

what are the differences between char and nchar? : Sql dba

1068

What is acid property in a database?

984

Can a select statement fire a trigger?

1103

What is mdf ldf and ndf?

941

How can we store rows in PL/SQL using array?

1170