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: Remove rows from a cursor?

Re: Remove rows from a cursor?

From: Brian Brane <brian_brane_at_msn.com>
Date: 3 Jul 2002 04:27:15 -0700
Message-ID: <24e540ea.0207030327.3d17784f@posting.google.com>


I was able to make this work by adding to the WHERE clause:

    thru <= (select min(thru) from [table] where thru >= [Jan 31])

This is surprisingly quick and does seem to eliminate the need to modify the cursor. However, for future reference, I'd still like to know if there is a way to either remove rows from a cursor or to create a result set based on logic in a stored procedure. Thanks! Received on Wed Jul 03 2002 - 06:27:15 CDT

Original text of this message

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