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 is trigger types in sql?

941

How do I create a memory optimized filegroup?

903

How delete all records from table in sql?

927

What are the two different parts of the pl/sql packages?

1023

how can we optimize or increase the speed of a mysql select query? : Sql dba

881

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

952

How to test for null values?

979

what are the advantages of mysql in comparison to oracle? : Sql dba

936

Is sql low level language?

957

What is numeric function sql?

982

what is 'mysqldump'? : Sql dba

1046

what is bcp? When does it used? : Sql dba

932

How do you exit in sql?

1061

Is it possible for a table to have more than one foreign key?

972

Can primary key be changed?

862