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 nvarchar in sql?

916

What is set serveroutput on in pl sql?

1272

What is full join in sql?

973

What is a left inner join?

995

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1094

How do you get column names only for a table (sql server)?

1140

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

993

What is embedded sql what are its advantages?

1016

What is the difference between microsoft sql and mysql?

951

Who is the owner of mysql database?

1036

What is self-join and what is the requirement of self-join?

1130

What are the different types of functions in sql?

1037

how to get help information from the server? : Sql dba

918

What does the base_object_type column shows in the user.triggers data dictionary view?

1029

What is record type in pl sql?

977