Re: Data Output in Text Format

From: takesiro <takesiro_at_coral.ocn.ne.jp>
Date: Tue, 23 May 2006 19:42:21 +0900
Message-ID: <e4uouf$mh8$1@news-est.ocn.ad.jp>

Hi!

You have another way.
Only beware, When you load text in Excel, it have to check delimiter',' + SPACE. Regards.

<SQL>

WHENEVER OSERROR        EXIT    98
WHENEVER SQLERROR       EXIT    99

DEFINE file_pathname = &1

SET HEADING OFF SET TERMOUT OFF
SET ECHO OFF SET FEEDBACK OFF SET PAGESIZE 0
SET LINESIZE 60 SET COLSEP ','
COLUMN COL_A FORMAT A3
COLUMN COL_B FORMAT A1
COLUMN PART_NO FORMAT A15
COLUMN TO_CHAR(IN_DATE,'YYYY/MM/DD') FORMAT A10 COLUMN TO_CHAR(OUT_DATE,'YYYY/MM/DD') FORMAT A10 COLUMN RANK FORMAT 999999 SPOOL &&file_pathname

SELECT
COL_A,
COL_B,
PART_NO,
SRC_RULE_NAME,
TO_CHAR(IN_DATE,'YYYY/MM/DD'),
TO_CHAR(OUT_DATE,'YYYY/MM/DD'),
RANK
FROM TABLE_A; SPOOL OFF EXIT 0 "Sameer" <dolpheen_at_gmail.com> wrote in message news:1148368075.948903.133870_at_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 - 05:42:21 CDT