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

will it be of help if you lapd, rpad to add those much spaces where
ever you want..

On 22/06/2010, Sven Aluoor <aluoor@xxxxxxxxx> wrote:
> Hi folks
>
> At the moment we make CSV files in UNIX scripts. Here an example.
>
> SELECT      serial
>          || ';'
>          || upd_time
>          || ';'
>          || MESSAGE
>          || ';'
>          || entity_table
>          || ';'
>          || action
>          || ';'
>          || status
>          || ';'
>          || act_msg
>          || ';'
>          || rss_name
>          || ';'
>          || rss_type
>          || ';'
>          || ADMIN
>     FROM trans
>    WHERE ess_user = '00000001' AND upd_time >
> to_date('25/05/2010','DD/MM/YYYY')
> ORDER BY serial DESC;
>
> Is it possible to make a native Excel sheet from UNIX? We need basic
> formatting of the resulting sheet.
> For example the field act_msg is a VARCHAR2 with 4000 Byte. In CSV
> this is a mess...
>
> cheers Sven
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================
--
http://www.freelists.org/webpage/oracle-l

Other related posts: