David Haynor <haynor_at_u.washington.edu>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:7nio9j$7ua$1_at_nntp6.u.washington.edu¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> hi oracle wizards,
>
> i'd like to make a query, and then export the results, with tabs between
> columns and newlines between rows, to a file readable by MS Excel.
> i believe that i can use SPOOL to do this, but how do i set the column
> separator to a tab?
>
> more generally, are there better ways to save the results of a query in
> an external file?
>
> thanks in advance.
>
> -dh
> -david haynor (haynor_at_u.washington.edu)
> department of radiology
> box 356004
> university of washington
> seattle, WA 98195
> (206) 543-3320
>
>
>
Use colsep!
SQL> COLSEP CHR(?); <-- ? is a ASCII code for Tab
Received on Mon Jul 26 1999 - 22:23:59 CDT
