Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Jobs not yet expired

Re: Jobs not yet expired

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 03 Feb 2007 09:10:51 -0800
Message-ID: <1170522651.333072@bubbleator.drizzle.com>


cvnkrishna wrote:
> Hi,
>
> Can somebody help me with the query/script with following requirements
> especially using "fnd_conc_requests_form_v".
>
> 1) Extract all jobs that are not yet "expired", but do have a "expiry
> date" that will be reached
> at some point
> 2) List all the jobs with their corresponding "Expiry Date"
>
>
>
> Regards,
>
> Vamsi Chikkam

What version of Oracle?
Show us what you've done so far to help yourself? SQL?
Search of http://tahiti.oracle.com
Search of http://asktom.oracle.com
Search of google

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Feb 03 2007 - 11:10:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US