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: sequence doesn't work ?

Re: sequence doesn't work ?

From: Bit Twister <BitTwister_at_localhost.localdomain>
Date: Mon, 02 Feb 2004 13:49:58 GMT
Message-ID: <slrnc1slc6.msi.BitTwister@wb.home.invalid> 





On Mon, 02 Feb 2004 14:45:09 +0100, krzys wrote:


> 

> select counter.currval from dual

> 

> but en error appears : ORA-08002: COUNTER.CURRVAL hasn't been defined in 

> ths session yet   ???????????????????




You use nextval to get a new sequence and if you need the same value
to place in other tables you use currval.
Received on Mon Feb 02 2004 - 07:49:58 CST












Original text of this message













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