Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Data Output in Text Format

Data Output in Text Format

From: Sameer <dolpheen_at_gmail.com>
Date: 23 May 2006 00:07:56 -0700
Message-ID: <1148368075.948903.133870@j55g2000cwa.googlegroups.com>


Hello,
I am having a view with 35 columns.
I want to operate on that data in Excel. Using Oracle SQL Developer, we can get the output in grid format, but we can't copy the respective field name. Is there any way to copy field names also?

So I tried to use the spool feature of Oracle. The output file is a text file. But I can't edit it in Excel. How to save the output in a format that will be available to process in Excel. e.g. tab limited.
Please help. Received on Tue May 23 2006 - 02:07:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US