Re: Display last records in a table

From: Jørn Hansen <joh_at_stibo.dk>
Date: Wed, 30 May 2001 15:15:19 +0200
Message-ID: <991228400.636642@radon.stibo.dk>

"fumi" <fumi_at_tpts5.seed.net.tw> wrote in message news:9etqvj$hue$1_at_news.seed.net.tw...
> > - By looking for the SCN of the datablock, we should be able to find the
> > block where the last commit was performed.
> > - If the database is running in archive mode. One could use logminer to
find
> > the last insert-statements performed against the table.
>
> The SCN is irrational here.
> A SCN is correspondent to a commit, not to a row.
>

I don't follow you? The SCN is stored with the datablock. Received on Wed May 30 2001 - 08:15:19 CDT