Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Remove rows from a cursor?
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