September 27th, 2013, 11:29 AM
Connect to oracle db & write SQL results into excel file
i would like to connect to oracle database and would like to execute series of SQLs and write those SQL results into Excel file (sheet1).
could some one help with the perl script please.
i am very new to perl.
my requirement is simple :
select count(*) from emp;
select count(*) from dept;
print the same SQLs in A column and result should be in B column in excel file.
column A column B
select count(*) from emp; 14
select count(*) from dept; 4
could someone help with the perl script please.
thanks in advance,
September 30th, 2013, 01:57 PM