Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)

From: Sven Aluoor <aluoor_at_gmail.com>
Date: Wed, 23 Jun 2010 11:51:57 +0200
Message-ID: <AANLkTilgvNeVfmObZ0ltI8hnpSNPQLw2U8I3kGpYwGQV_at_mail.gmail.com>

On Tue, Jun 22, 2010 at 7:50 PM, chet justice <chet.justice_at_gmail.com> wrote:
> You could also do it from SQL*Plus if you wanted:
>
> http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:68212348056#15410901253486
>
> Hi Tom,
>
> I know a nice way to make Excel sheets from sqlplus. You can use the markup html tag in sqlplus.
> Here's an example.
>
> SET LINESIZE 4000
> SET VERIFY OFF
> SET FEEDBACK OFF
> SET PAGESIZE 999
>
> SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
>
> SPOOL c:\temp\test_xls.xls
>
> SELECT object_type
> , SUBSTR( object_name, 1, 30 ) object
> , created
> , last_ddl_time
> , status
> FROM user_objects
> ORDER BY 1, 2
> /
>
> SPOOL OFF
>
> SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON
>
> SET LINESIZE 2000 VERIFY ON FEEDBACK ON
Hi Chet

this makes HTML output, but you can edit with Excel. Seems to be simple and nice solution

cheers Sven

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 23 2010 - 04:51:57 CDT