Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: To find a just-inserted record
raghu wrote:
>
> S P Arif Sahari Wibowo <arifsaha_at_yahoo.com> wrote in message news:<Pine.LNX.4.42.0112210942380.28418-100000_at_macbeth.tirone.com>...
> > Hi!
> >
> > Do you know how to make sure we can found a record that we just inserted?
> >
> > Obviously this is in programming context, a routine just execute an
> > 'insert' sql command, but have to pass the rowid of that record to other
> > routines. Obviously the rowid cannot be known before the record is
> > inserted.
> >
> > Any idea how to keep a 'hold' on that newly inserted record?
> >
> > I try this on an Oracle 8.1.6 on Red Hat Linux using perl's DBI.
> >
> > Thank you!
>
> hi arif
> th solution is to max of all the rowid s available so that we can get
> the most recent ly inserted record.
>
> raghu
> Certified DBA
Hmmm, what about when lots of different processes are inserting at the
same time?
-- Ron Reidy Oracle DBAReceived on Fri Dec 21 2001 - 14:19:00 CST