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 do I edit a stored procedure?

988

Can one improve the performance of sql*loader? : aql loader

1037

What is the maximum database size for sql express?

1014

What is a variable in sql?

990

What is dml and ddl?

946

difference between anonymous blocks and sub-programs.

1123

What is pl sql commands?

1034

What types of commands can be executed in sql*plus?

1100

What are the different types of tables in sql?

992

Why is nosql good?

1014

what is the difference between char and varchar data types? : Sql dba

1070

What are the types of queries in sql?

1072

how to fetch common records from two tables? : Sql dba

1168

what are date and time functions in mysql? : Sql dba

968

What is the syntax to add a record to a table?

1079