[linux] RE: Last record in table
Vincenzo Jon - IL
VINCENZOJ na tusc.com
Pátek Leden 28 21:21:22 CET 2000
Try doing it via a cursor in pl/sql. That way you can set the value in a
vriable and use it over and over again within that same procedure.
Just my $0.02
Jon Vincenzo
TUSC
Lombard, IL
> ----------
> From: Gogala, Mladen[SMTP:MGogala na oxhp.com]
> Reply To: ORACLE-LINUX-L na fatcity.com
> Sent: Friday, January 28, 2000 12:59 PM
> To: Multiple recipients of list ORACLE-LINUX-L
> Subject: RE: Last record in table
>
> 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.
>
> --
> 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).
> --
> 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: Gogala, Mladen
> INET: MGogala na oxhp.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).
>
--
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: Vincenzo Jon - IL
INET: VINCENZOJ na tusc.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).
Další informace o konferenci linux