Re: Retrieving the prior record

Hi John..

There is a PL/SQL table method called 'prior'....so,

plsql_table(i).prior should do it (note the 'dot' before the word prior)

Hope this helps,

Steve

John Johnson wrote:

> I need to take any record in a table, given the key, and retreive the
> immediately prior record in the table.
> All of the records have a sequence number, I just cannot figure out what the
> PL/SQL should look like.
>
> Thanks
> -John
  Received on Thu Jul 12 2001 - 09:08:47 CDT