Re: Batch Job for Oracle

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@xxxxxxxxxx> wrote in message
news:fhn1eh$1e5$1@xxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Excel vs Access
    ... MS Query is built into excel complete with setup wizard. ... The supervisor will review the report to see if, ... Whether you use another Excel workbook for the data, or an Access database ...
    (microsoft.public.excel.misc)
  • Re: why>?
    ... pivot can help to form these. ... Excel is WORTHLESS I mean you dipshits are the ones that need to get ... A database junkie who doesn't understand anything except how to ... produce a standardized, scalable, and replicable report, even if the ...
    (microsoft.public.excel)
  • Re: apache - dbi - running jobs after browser closed
    ... We have an apache server interfaced on a linux box to an oracle ... database, 9i. ... There is a monster sql generated report that a web users can execute. ... Another way is to kill the report. ...
    (comp.databases.oracle.server)
  • Re: Automatic Periodic Query Export
    ... > Settings\tli6\Desktop\today ecn report'. ... > transfering the query to an excel sheet) ... >> when the database is first opened. ...
    (microsoft.public.access.externaldata)
  • apache - dbi - running jobs after browser closed
    ... We have an apache server interfaced on a linux box to an oracle ... database, 9i. ... There is a monster sql generated report that a web users can execute. ... Another way is to kill the report. ...
    (comp.databases.oracle.server)