> >create table result_index (
> > session_id number(10),
> > myrowid varchar(30),
> > myrownum number(10),
> > mydate date
> >);
> >
> >insert into result_index select 123456,rowid,rownum,sysdate from
> your_table;
>
> The problem with this is that it also destroys first row behaviour. When
> the insert has started running i would like to display the first rows.
>
> I am thinking about a solution that only inserts the rows the
> user has seen
> and repeats the select (excluding these rows) if he wants to see
> others. I
> just havent found an elegant PL/SQL way to implement this.
select blah
from foo
where bar=baz
and rowid NOT IN (
select myrowid
from result_index
where session_id = ?
)
would be how to exclude rows already seen.
