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

Home -> Community -> Usenet -> c.d.o.server -> Re: Entering dynamic data into 2 fields

Re: Entering dynamic data into 2 fields

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Wed, 21 Jan 2004 15:43:34 -0500
Message-ID: <WtBPb.188$l4.1025@tor-nn1.netcom.ca>


Use curval

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"johnnyr77" <johnnyr77.10e3mb_at_mail.mcse.ms> a écrit dans le message de
news:johnnyr77.10e3mb_at_mail.mcse.ms...

>
> Just figured it out myself!
>
> FYI:
>
> NEXTVAL does not change until the next record. so when I call it twice
> within the same insert record the value is the same both times.
>
>
> johnnyr77
> ------------------------------------------------------------------------
> Posted via http://www.mcse.ms
> ------------------------------------------------------------------------
> View this thread: http://www.mcse.ms/message306905.html
>
Received on Wed Jan 21 2004 - 14:43:34 CST

Original text of this message

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