Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieving the key of a newly inserted record

Re: Retrieving the key of a newly inserted record

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 23 Dec 2002 09:31:10 -0600
Message-ID: <ud6nsdaag.fsf@standardandpoors.com>


On 21 Dec 2002, claus_scherschel_at_operamail.com wrote:
> Galen Boyer <galenboyer_at_hotpop.com> wrote in
> news:usmwsxupy.fsf_at_standardandpoors.com:
>

>> Come on my man.  You got the answer about sequences and you
>> couldn't search for the term currval somehow?

>
> Galen,
>
> I'm sorry for that. My posting came a little bit to quick. I
> was trying out what you've been proposing and got stuck
> again. I did not understand the ...from dual that must be used
> when selecting nextval/currval.
>
> Now I've got that, too.
>
> My thanks and excuses,

No problemo. If you were struggling with the "from dual" part, then I can see that each word in the sql phrase might have caused you to go looking something up, which then takes you down paths of reading you don't intend... Come back up for air ... What was I originally trying to do?

-- 
Galen Boyer
Received on Mon Dec 23 2002 - 09:31:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US