[linux] Last record in table

[Martin Dolog]

Pedro Fradique da Silva wrote:
> 
> 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.


SOME SQL SERV. HAVE FUNCTION WHICH
RETURN LAST ID
LAST EXECUTED IN INSERT STATEMENT. FOR
INSTANCE MYSQL HAS IT.

ORACLE HAS SOMETHING LIKE TRANSACTIONS;
LOOK AT FUNCTIONS BUILT IN SERVER NOR
USE ANOTHER SELECT FOR JUST INSERTED
VALUES;
MAKE ALL THIS LIKE ONE ATOMIC OPERATION
- TRANSACTION
WHERE ONLY YOU CAN SEE JUST INSERTED
RECORD - BEFORE
CALLING COMMIT OF COURSE;

BEGIN TRANS
INSERT INTO ....
SELECT FROM ... /// FOR ID
INSERT INTO ....
....
COMMIT;
OR ROLLBACK IF NOT OK;

OR READ MANUAL :)



> 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.
> 
> --
> 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: Pedro Fradique da Silva
>   INET: fradique na ipimar.pt
> 
> 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).

-- 
#md