Re: SQL Selection Set Questions
Date: 1997/01/01
Message-ID: <5aeht6$da6_at_news.istar.ca>#1/1
I would need more info on exactly what you are trying to do... But by the looks of things you will need to use a PL/SQL curser which allows you to store rows of a certain row type that YOU define. By opening and closing the curser you can compare values row by row and make updates at the same time. Vague, but hope this helps...
Cheers, Robert.
>WebMaster_at_HyperNetUSA.com (Larry W. Berman) wrote:
>After performing a SQL select on a table, I need to then know how to work
>with the selection set to:
>1. Step through each record (row)
>2. Retrieve the value for a specific field in each row
>3. Set the value of a specific field in each row
>4. Run another SQL select with an "order by" parameter against the first
>selection set to create a new sorted set.
>Thanks for your help.
>Larry Berman
Received on Wed Jan 01 1997 - 00:00:00 CET