I have a query called in a CSH script which is a simple select. I would like to write the result of the select statement in a a flat file but when i set the "SET HEADING OFF" and "SET FEEDBACK OFF", i get a blank line written to the flat file. When i executed the query in SQLPLUS and the settings off, i really had some spaces.
SQL> SET HEADING OFF
SQL> SET FEEDBACK OFF
SQL> select employee_id||','||first_name||','||last_name row_list
> from employees;
I got a blank in the first result where the column name used to reside. And in between the result set, i also get some blank lines because of the default page size. No matter how i set the page size, i still don't know how will i know how long the data/result will be, meaning at one point there will still be a blank space that will be written in the flat file. Is this something that can be set to SQLPLUS or in the CSH script??