Re: EXPORTING FROM ORACLE V7 TO MS EXCEL

From: Kyoungrok, Lee <tunnel_at_hanmail.net>
Date: Tue, 27 Jul 1999 12:23:59 +0900
Message-ID: <Hy9n3.3$mr1.169@news.hananet.net>

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