Create output file with | pipe delimiter.

October 6, 2011 at 08:25:46
Specs: Windows 64
When I spool my query:

spool output.txt;
select * from users;
spool off;

The output.txt file is only showing: select * from users;

Need the output file to actually contain the results of the query. Am I missing a step?

See More: Create output file with | pipe delimiter.

November 29, 2011 at 20:53:11
Hi StvJyce,
If the output.txt has the value "select * from users", then spooling seems to be not having any issues.

I beleive there are no rows in the table 'users'.

For pipe delimition, use the below, suppose users table has 3 columns,
select field1 || '|' || field2 || '|' || field2 from users;
will give you the delimited values.

Report •
Related Solutions

Ask Question