HOW TO SET SEQUENCE VALUE

  • From: jose soares <jose.soares@xxxxxxxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 29 Mar 2012 12:15:23 +0200

Hi all,

I'm trying to SET a sequence VALUE but seems it can't be done on oracle.

PostgreSQL allows to do such thing in this way:

SELECT setval('mysequence', 42);   -- setting value to 42


Is there a way to do the same thing in Oracle?

thanks
j

/
/ 

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2012