How to copy a table in another table with datas?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of nvl function?

767


What is break?

841


How do you explain an index number?

744


What are the syntax and use of the coalesce function?

768


what are the types of subquery? : Sql dba

765






Explain the the delete statements in sql?

749


How is indexing done in search engines?

716


what are sequences

1312


How to test for null values?

763


How can I get the number of records affected by a stored procedure?

761


what is the functionality of the function htmlentities? : Sql dba

690


What is offset in sql query?

820


How to convert comma separated string to array in pl/sql?

807


What is difference between joins and union?

742


Explain the structure of pl/sql in brief.

788