Good day
I wanted to ask for little tip about batch job for Oracle..
In fact I have no big experience in oracle, only some basic
administration,
good ODBC with excel, some programming skills, when I need to write a
script
or small application..
Ok, let's go to the point...
We have oracle database with some infos, and I need to create periodical
re****ts generated periodically (weekly, monthly, daily, etc). For now we
are
using my Excel sheet with VBA code, but this thing is not very good,
because
it consumes somebody's time and (what is worse) user needs to have Oracle
client software installed on the machine.. It does not make any sense, to
have client to get one re****t per month...
So I wanted to create a batch job, which can be started with WIndows
Scheduler and execute sql query on selected database - rest is easy for
me...
I tried to search google, but I quickly get lost - I wanted something what
is a simple freeware tool, or (even better) is included in oracle
installation (version 9). Only thing I found are some high cost software
with lots of unnecessary junk..
Do you have any idea for this trouble?
Regards
Michal
|
