Re: Make use of the built-in functions for Tables

dennis.pong_at_gmail.com wrote:
> based on original ordering of the table. I was given the table without
> being told of the id as well. So I'd believe it's individual_id, a
> column in the table. But yes, there might be multiple individual_ids
> representing the minimum records and maximum records.
>
>
> But that's not the point. My point is whether I could make use of the
> .first and .last properties of the cursor. If so, what'd be the proper
> way to set it up, if I haven't already.
>
> Thanks,
> -DP

Tables have no order unless they are IOTs or sorted hash clusters.

The default tables in ALL database products are heap tables. They are just heaps of unordered records. If you want first and last you need to attach labels.

There is no proper way. It appears from what you've posted your data does not support what you are trying to do. I would suggest you see the data architect who designed it and ask them how they think you should accomplish the business requirement.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org