From: Guido.Konsolke@triaton.com   
      
   "R.A. Joemman"  wrote...   
   > Hi,   
   >   
   > I try to export a table from sqlplus to a ascii file like this:   
   >   
   >   
   > select  col1 || ';' || col2 || ';' || .....  || ';' || colN   
   > from    mytable ;   
   >   
   (snip)   
   >   
   > How do I export those wide tables?   
   >   
   > Best regards   
   > Raoul   
      
   Hi Raoul,   
      
   another solution that might work for you:   
   use the sql*plus command 'SET COLSEP'.   
      
   hth,   
   Guido   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)