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 does the sign mean in sql?

507

explain the delete statements in sql

583

Which sql most popular?

556

How to call shell script from pl sql procedure?

625

how to create a table index in mysql? : Sql dba

597

how to rename an existing column in a table? : Sql dba

514

Which tcp/ip port does sql server run?

534

Explain what is a subquery ?

656

what is row? : Sql dba

712

What is the use of count (*) in sql?

547

What is the difference between numeric and autonumber?

500

difference between anonymous blocks and sub-programs.

622

Is it possible to pass parameters to triggers?

575

Can a view be mutating? If yes, then how?

578

How to write html code in pl sql?

580