Hi Team, i need to know how to generate insert sql query for select statement. Before I can able to generate with sql developer application. But currently its not available. Can you please anyone help on this. Thanks in advance.🙏🏻
top of page
bottom of page
INSERT INTO my_table (col1, col2, col3)
SELECT col1, col2, col3
FROM other_table
WHERE col4 = 'some_value';