Re: Batch Job for Oracle

From: Tony_Miller <NoWayToday_at_yahoo.com>
Date: Sat, 17 Nov 2007 11:10:19 -0600
Message-ID: <473f20b7$0$20588$4c368faf_at_roadrunner.com>


application express.. it installs into the database, you build the report and have it dump as an excel spreadsheet whenever the user wants.. all they need is a browser to access it!

"Michal AKA Miki" <jakistammichal_at_z.onetu.pl> wrote in message news:fhn1eh$1e5$1_at_news.onet.pl...
> 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
> reports 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 report 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
>
Received on Sat Nov 17 2007 - 18:10:19 CET

Original text of this message