Re: Display last records in a table

BTW: Before anyone jumps on my statement about the table dump- I know that dumping isn't a guarantee of order, that's what is funny about it, people do the dump THINKING this is the best way to view the last records. There is no good way to do this - live with it or without it. You can't fool mother nature or Larry Ellison.

On Tue, 29 May 2001 17:47:53 -0500, Michael Dodd <doddme_at_mindspring.com> wrote:

>Good god! You're right. Sorry - there is no way to do that in
>Oracle. Too bad.... Try another DBMS.
>
>Or...
>
>I was making the assumption that someone just wanted to look at some
>recently added records, they didn't have a timestamp, or a sequence
>numbered field available. They didn't want to do a dump of the whole
>table to look at the later records (In real life, I've actually seen
>this done - believe it or not!) This was just a quick way of looking
>at the bottom of a dump. Since they chose the number 10, and not
>records added since a certain date, it sounded a little arbitrary.
>
>I know that Oracle does not guarantee where it will store a given
>record. I like the timestamp field too. But, I often find myself
>trying to offer some solution in real life situations rather than tell
>people 'You can't do that...' It's a little like telling people who
>ask you for directions that they should use the map they should have
>packed. If they don't have the map, they obviously can't use it, they
>still need to get there somehow.
>
>Happy Tuesday.
Received on Tue May 29 2001 - 17:53:38 CDT