SQLPLUS : set sqlformat insert : SP2-0158

I want to export all my datas as insert statement. In Sql Developer, the command “set sqlformat insert” work very well… but when I want to use it on sqlplus, I have this error message : SP2-0158 unknown SET option “sqlformat”

This command work when it’s use on a script but i’ve made a script :

spool /data/scripts/result/test.sql
set sqlformat insert;
select * from mytable;
spool off

I’ve try the same code on SQLdev and it works…

How can I use it correcly on sqlplus ?

Answer

sqlformat insert is NOT an sqlplus acceptable format, try it with sqlcl. It should work (and allow you to use the same setting as you can do in sqldev)