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: How to: Retrieve Sequence.NEXTVAL into a variable

Re: How to: Retrieve Sequence.NEXTVAL into a variable

From: BluesMan <ygrenet_at_club-internet.fr>
Date: Sat, 14 Nov 1998 04:32:46 +0100
Message-ID: <72ith8$hr6$1@front3.grolier.fr> 





the dual table is a one row table with only one column (with X value)...
select sysdate from dual; will give you the current date/time for
instance...



Kostya Ogrodnichy a écrit dans le message
<910963859.163718_at_ns.kpvti.kiev.ua>...


>


>


>select MySequence.nextval into MyVar from dual;





Received on Fri Nov 13 1998 - 21:32:46 CST












Original text of this message













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