From: "Steve McDaniels" <steve.mcdaniels@sierra.com>
Subject: Re: Get the primary key of the last record added
Date: 1997/05/05
Message-ID: <01bc5983$5d64b480$030914ac@SteveIP.corp.sierra.com>#1/1
References: <5jhkud$um9@zam201.zam.kfa-juelich.de>
Organization: Sierra On-Line
Newsgroups: comp.databases.oracle.server



won't this do it?

Query A: select max(rowid) from <table>;

select <keyed field> from <table> where rowid = chartorowid(<rowid from
query A>);


Christoph Geisse <Ch.Geisse@kfa-juelich.de> wrote in article
<5jhkud$um9@zam201.zam.kfa-juelich.de>...
> Hi,
> 
> does anybody know how to get the primary key of the last record added to 
> a table? (ORACLE 7.2, SQL)
> 
> Regards,
> Christoph
> -----------------------------------------------------------------------
> Von/From    Christoph Geisse                  Forschungszentrum Juelich
> Tel./Phone  (02461)61-2128                    ASS-BS
> Mail        Ch.Geisse@kfa-juelich.de          D-52425 Juelich, GERMANY
> 
>