title: ORACLE: need to export table data without spaces between columns
body: <p>Say i have Table A with columns </p>
  
  <pre><code>      col1   col2   col3   col4
        -------------------
        sajal  singh  28     IND
        hello  how    are    you
  </code></pre>
  
  <p>I want to export the data into a flat file without spaces or tabs between columns
  So the output should be </p>
  
  <pre><code>      cat dump
        sajalsingh28IND
        hellohowareyou
  </code></pre>
  
  <p>what i have tried. i have written a script </p>
  
  <pre><code>      #!/usr/bin/bash
  
        #the file where sql output will go
        OUT=report.txt
        &gt;$OUT
        DESC=desc.txt
        &gt;$DESC
  
        sqlplus -s "xxx/xxx@xxx" &lt;&lt; END_SQL &gt; /dev/null
  
        set pages 0
        set feedback off
        set heading off
        set trimspool off
        set termout off
        set verify off
        set wrap off
  
        SPOOL $DESC
  
        Select * from table_name;
  
        SPOOL OFF
  
        END_SQL
  </code></pre>
  
  <p>But i am getting outputs of one row in multiple lines and with tabs/spaces</p>
  
  <ol>
  <li>So question is how can i fix that? and </li>
  <li>I found some data pump utilities like expdp. Can i use that in Unix? if yes, how can i acheive the dump in that format?</li>
  </ol>
  
  <p>Thank You </p>