HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: Sven Aluoor <aluoor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 22 Jun 2010 16:49:30 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
