How do I format my oracle queries so the columns don t wrap

Question

I ve tried this  but it doesn t work   col   format a20000   Do I really have to list every column specifically   That is a huge pain in the arse

User · Answer

I use a generic query I call  dump   why  I don t know  that looks like this   SET NEWPAGE NONE SET PAGESIZE 0 SET SPACE 0 SET LINESIZE 16000 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT OFF SET TRIMOUT ON SET TRIMSPOOL ON SET COLSEP    spool  amp 1  txt     amp 1  spool off exit   I then call SQL Plus passing the actual SQL script I want to run as an argument   sqlplus -S user password database  dump sql my real query sql   The result is written to a file      my real query sql txt

User · Answer

I use a generic query I call  dump   why  I don t know  that looks like this   SET NEWPAGE NONE SET PAGESIZE 0 SET SPACE 0 SET LINESIZE 16000 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT OFF SET TRIMOUT ON SET TRIMSPOOL ON SET COLSEP    spool  amp 1  txt     amp 1  spool off exit   I then call SQL Plus passing the actual SQL script I want to run as an argument   sqlplus -S user password database  dump sql my real query sql   The result is written to a file      my real query sql txt

User · Answer

Never mind  figured it out   set wrap off set linesize 3000 --  or to a sufficiently large value to hold your results page    Which I found by   show all   And looking for some option that seemed relevant

User · Answer

Never mind  figured it out   set wrap off set linesize 3000 --  or to a sufficiently large value to hold your results page    Which I found by   show all   And looking for some option that seemed relevant

User · Answer

set WRAP OFF set PAGESIZE 0   Try using those settings

User · Answer

Never mind  figured it out   set wrap off set linesize 3000 --  or to a sufficiently large value to hold your results page    Which I found by   show all   And looking for some option that seemed relevant

User · Answer

set linesize 3000  set wrap off  set termout off  set pagesize 0 embedded on  set trimspool on   Try with all above values

User · Answer

Never mind  figured it out   set wrap off set linesize 3000 --  or to a sufficiently large value to hold your results page    Which I found by   show all   And looking for some option that seemed relevant

User · Answer

I use a generic query I call  dump   why  I don t know  that looks like this   SET NEWPAGE NONE SET PAGESIZE 0 SET SPACE 0 SET LINESIZE 16000 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT OFF SET TRIMOUT ON SET TRIMSPOOL ON SET COLSEP    spool  amp 1  txt     amp 1  spool off exit   I then call SQL Plus passing the actual SQL script I want to run as an argument   sqlplus -S user password database  dump sql my real query sql   The result is written to a file      my real query sql txt

User · Answer

set linesize 3000  set wrap off  set termout off  set pagesize 0 embedded on  set trimspool on   Try with all above values

User · Answer

I use a generic query I call  dump   why  I don t know  that looks like this   SET NEWPAGE NONE SET PAGESIZE 0 SET SPACE 0 SET LINESIZE 16000 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT OFF SET TRIMOUT ON SET TRIMSPOOL ON SET COLSEP    spool  amp 1  txt     amp 1  spool off exit   I then call SQL Plus passing the actual SQL script I want to run as an argument   sqlplus -S user password database  dump sql my real query sql   The result is written to a file      my real query sql txt

User · Answer

set WRAP OFF set PAGESIZE 0   Try using those settings

[oracle] How do I format my oracle queries so the columns don't wrap?

Examples related to oracle

Examples related to sqlplus