Subject spooling isql results to file ??
Author to_grille
hi group,
I'm looking for a way to get existing data in a table, spooled to a
text-files as insert statements.
This works so far, using this script:

OUT inserts.SQL;
SELECT 'INSERT INTO ANY_TABLE VALUES('|| some_id|| ','|| some_other_id
|| ','''|| some_name || ''');' FROM ANY_OTHER_TABLE;

the problem is, I'm getting lots of empty lines in between the result
lines (not that big of a problem) but also this lines every view
result lines.




How do I get rid of those ??
thanx for any help