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

Is sql developer case sensitive?

944

Why is pl sql needed?

874

What does the hierarchical profiler does?

1003

What is difference between group by and partition by?

977

What are different types of sql?

1099

What is query execution plan in sql?

1128

How do I trace sql profiler?

920

What is the meaning of disabling a trigger?

1111

Why do we need unique key in a table?

883

Can you skip header records while loading? : aql loader

973

How do I view tables in sql developer?

884

What are the constraints available in sql?

995

How to assign sql query results to pl sql variables?

992

What is the use of sqldataadapter?

907

What is sql server and ase?

976