Re: How to Schedule Query Execution ?

From: jonwat <jonwaterhouse_at_mail.gov.nf.ca>
Date: 30 Aug 2006 06:05:20 -0700
Message-ID: <1156943120.126379.39340@i42g2000cwa.googlegroups.com>

Pankaj_Jha wrote:
> Dear All,
>
> I have written a SQL Query for generating report. I want this query to
> get executed automatically every day at 9:00 AM. Suppose the query is
> like this
>
> Select e.empname, e.dept, s.basicsalary, s.hra, s.da, s.grosssalary
> from employee e, salary s
> where e.empid=s.empid
>
> Can U tell me how to do this.
>
> Thanks in advance
>
> Pankaj Jha

Check out:

http://asktom.oracle.com/pls/ask/f?p=4950:8:2782851770239135314::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:633537913184 Received on Wed Aug 30 2006 - 08:05:20 CDT