Question

write the create,insert and select command in oracle
​

Answer 1

Answer:

it, you use the Oracle INSERT INTO SELECT statement as follows: INSERT INTO target_table (col1, col2, col3) SELECT col1, col2, col3 FROM source_table WHERE condition; The Oracle INSERT INTO SELECT statement requires the data type of the source and target tables match.

Explanation:

plz mark as brilliant