select语句批量拼装sql语句

spool c:\data.sql;
select ‘insert into table_name values(”’||field_1||”’,”’||field_2||”’);’from table_name where field_n=some_conditon;
spool off;