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 -> foocounter.CURRVAL

foocounter.CURRVAL

From: Frank <franjoe_at_frisurf.no>
Date: Thu, 15 Mar 2001 16:51:29 +0100
Message-ID: <GC5s6.241$ph3.1503@news1.oke.nextra.no> 






Hi!



foocounter.currval will contain the last generated sequence no after you
have inserted.



Before ANY number is generated in the current session, you will get the
message:



"ORA-08002: sequence foocounter.CURRVAL is not yet defined in this session"



Frank



eg.


SELECT foocounter.currval


FROM DUAL;

Received on Thu Mar 15 2001 - 09:51:29 CST












Original text of this message













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