Hi all,
I have tables with 40 columns, and I need to be able to query the data from this table with the below condition:
1. data can't break to the second line so I have as follow:
SQL> set linesize 1000
SQL> set wrap off
SQL> set heading off
SQL> spool foo.cvs
2. how can I be sure data of each column goes into its own columns so I can reload this data
