Re: Cursors with multiple selects

From: Tom Best <tombest_at_firstusa.com>
Date: 9 Oct 2001 09:44:25 -0700
Message-ID: <99ab87b0.0110090844.750866b2@posting.google.com>

"Vigi98" <vigi98_at_my-deja.com> wrote in message news:<3bc2afc3$0$3643$626a54ce_at_news.free.fr>...
> Hi all,
>
> I'm wondering if it is possible to fill in a cursor in another way that
> "OPEN CURSOR FOR SELECT...".
>
> Eg, is it possible to fiil in it with several select ?

You can use UNION to combine select statements. This is not anything peculiar to cursors. It is just standard SQL.

HTH,
Tom Best Received on Tue Oct 09 2001 - 11:44:25 CDT

This message: [ Message body ]
Next message: ftp: "Why I cannot use the sample program?"
Previous message: Sybrand Bakker: "Re: How to return a recordset to caller by STORE PROCEDURE?????????"
In reply to: Vigi98: "Cursors with multiple selects"
Next in thread: Kock, Gerd: "Cursors with multiple selects"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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