--- On Fri, 20/3/09, anbu mani <[email protected]> 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/ _______________________________________________ To unsubscribe, email [email protected] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
