Re: FETCH a cursor inside a SELECT

On 30 Nov 2002 at 0:09, David Crawshaw wrote:

> On Sat, 30 Nov 2002 12:00 am, Shridhar Daithankar wrote:
> > Not too sure but how about inserting the variable to be passed in a
> > single row table and select on that table from view definition?
>
> Now that's a hairy one! I bet it would work too, but I have multiple
> users on this db. :-(

I realised that after I shot the answer. Not to sure what I am saying here but
how about the join on that view and the single column table? Will that solve
your problem?

Essentially same as what you have said but just in a different code
organisation and that certainly would be readable all along..:-)

Bye
 Shridhar

--
Every living thing wants to survive.        -- Spock, "The Ultimate Computer",
stardate 4731.3