HOW TO SET SEQUENCE VALUE
From: jose soares <jose.soares_at_sferacarta.com>
Date: Thu, 29 Mar 2012 12:15:23 +0200
Message-ID: <4F74363B.6040305_at_sferacarta.com>
Hi all,
Date: Thu, 29 Mar 2012 12:15:23 +0200
Message-ID: <4F74363B.6040305_at_sferacarta.com>
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
/
/
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 29 2012 - 05:15:23 CDT