All,

A small lack of know-how:

How do I output an sql-plus(8) generated query to a file?

From the SQL > spool {filename with path}

Then run your query.

Then from the SQL > spool off

In windows, if the output isn't too long, you can copy and past into other applications like excel.

Note, you might have to set linesize and set pagesize.



Originally posted by en@frrom
All,

A small lack of know-how:

How do I output an sql-plus(8) generated query to a file?

thanks!