To export query results into an INSERT text file, you can use Oracle SQL Developer or Oracle SQLcl

In the realm of oracle database management, engineers often rely on robust tools to streamline their workflows and enhance productivity. Two such indispensable tools are Oracle SQL Developer and Oracle SQLcl (command line).

Both tools serve distinct purposes but are equally valuable in an engineer’s toolkit. Whether you prefer the graphical interface of SQL Developer or the scripting prowess of SQLcl, mastering these tools can significantly enhance your database management skills and efficiency.

Sql Developer

set sqlformat json
select /insert/ * from bigdba.table

Also on Sqlcl

SET SQLFORMAT INSERT
SPOOL myoutput.sql
SELECT * FROM your_table;
SPOOL OFF;