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;
EXIT;
------------

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.

-----------

CONCATENATION











===================================================
-----------

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