How to copy the record from one table from another table

Question

how to do in oracle only

Answer 1

why do you want to do this? if the tables are in the same schema you should think about your database design. If not, you should be able to export a table to json or CSV and import it to the other Database (for example in phpMyAdmin)

Answer 2

I know how to do in php myAdmin but I want in oracle