[linux] Re: Last record in table

[Jeff Sharpe]

I agree - think data.  Do a max() on a create date field or a sequence
to get the last record.  

If you want to use the same value from the original insert into the
second, use PLSQL and variables.

And don't lock the table.

J

"Gogala, Mladen" wrote:
> 
> There is no such thing as the last record of a table. Table data are not
> ordered in
> any particular way. Think RDBMS, not file system.
> 
> -----Original Message-----
> Sent: Friday, January 28, 2000 11:12 AM
> To: Multiple recipients of list ORACLE-LINUX-L
> 
> Hi all,
> After inserting a record I'm trying to retrieve the last record in a
> table(that would be the one I just inserted), so I can use one of its
> values in another insert.
> Is there a simple way to do it?
> How can I lock the database so that nothing is done between that first
> insert and the select?
> Thanks for any help,
> Pedro.

--
Jeff Sharpe
Programming and Database Manager, NetNation Communications Inc.
604-688-8946, ext 106
-- 
Don't forget!  Abstracts are due January 25th 2000.  Act now and make your
reservations for ODTUG 2000 -- the best conference of the new century!  See
the website at http://www.odtug.com for full details.
-- 
Author: Jeff Sharpe
  INET: jeff na netnation.com

Fat City Network Services    -- (619) 538-5051  FAX: (619) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru na fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-LINUX-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).