[Ilugc] Perl package !!

[Raman.P]

--- On Fri, 20/3/09, anbu mani <anbumanij at yahoo.co.in> wrote:
> 
>     I need to do the following activities on
> solaris server. Now we can go with linux .
> 
>    *) Need to take a table form oracle
> server and convert this into CSV in PERL. Using solaris.
> 
>       Kindly help me out in this note. Now
> the solaris server has only perl installed. Want to add all
> the modules related to oracle and CSV. How to do these
> things. If need to have CPAN how to install those things..

Use DBI for Oracle to fetch table data. Use Spreadsheet::Write to create the csv file.
 Spreadsheet::Write  help is at 
http://search.cpan.org/~amaltsev/Spreadsheet-Write-0.03/lib/Spreadsheet/Write.pm

Or even simpler may be using Spreadsheet-Writeexcel-fromdbquery. See at

http://search.cpan.org/~cpkois/Spreadsheet-WriteExcel-FromDB-Query-0.01/lib/Spreadsheet/WriteExcel/FromDB/Query.pm

Raman.P



      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/