Re: EXPORTING FROM ORACLE V7 TO MS EXCEL

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
>
>
>

Excel program can separate fields by delimeter(like comma, semicolon, etc) select like this

SQL> SELECT LAST_NAME||','||FIRST_NAME FROM S_EMP; And choose separator comma in Excel.
bye~~~~ Received on Mon Jul 26 1999 - 22:29:05 CDT