copy from user_name/password@schema_name insert target_table

How to copy a table in another table with datas?

Question Posted / meher

Answer Posted / meher

copy from user_name/password@schema_name insert
target_table_name using select * from source_table_name;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what are numeric data types? : Sql dba

1054

What is raid? How does it help storage of databases?

1075

What do you understand by pl/sql cursors?

1080

What is the basic structure of an sql?

1090

what is transaction? : Sql dba

1000

How does sql*loader handles newline characters in a record? : aql loader

1035

What is sql character function?

1061

What is query execution plan in sql?

1177

what are the differences between require and include, include_once and require_once? : Sql dba

1016

what is oracle database ? : Sql dba

1014

What is data types in sql?

995

explain about mysql and its features. : Sql dba

1008

how can we submit a form without a submit button? : Sql dba

977

Why do we use partitions in sql?

1038

Can we connect to postgresql using sql developer?

992