Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

empty line

happy10319Apr 24 2019 — edited Apr 30 2019

Hi,

I run a query:

set pagesize 0

--set feedback off

set verify off

spool file1.txt

select col1 from mytable;

At the end of file1.txt I have always an empty line.

Since I will read this file by another program to retrieve the values from it, the empty line is a problem.

Any way/setting to avoid it?

Thanks.

This post has been answered by L. Fernigrini on Apr 24 2019
Jump to Answer
Comments
Post Details
Added on Apr 24 2019
19 comments
632 views