Give a SQL, the query results in a file, separated by a delimiter, with spool separator is bad, I am after the results of a query into the file, the space with sed alternant operator, but if there is space in the data is wrong, how to do?

CodePudding user response:

Spool or lane separator!
Spool append a.t xt.
The select a1 | | '; '| | a2 | |'; 'the from t1 where rownum<=100;
Spool off;