what is the maximum value of MAXVALUE in sequence in oracle?

sql oracle oracle10g sequence
user1252398 picture user1252398 · Mar 7, 2012 · Viewed 45.4k times · Source

Could you tell me what is the maximum/minimum value of MAXVALUE in a sequence & what is the minimum/maximum value of MINVALUE in sequence?

Answer

Vishwanath Dalvi picture Vishwanath Dalvi · Mar 7, 2012

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm

MAXVALUE Specify the maximum value the sequence can generate. This integer value can have 28 or fewer digits. MAXVALUE must be equal to or greater than START WITH and must be greater than MINVALUE.

MINVALUE Specify the minimum value of the sequence. This integer value can have 28 or fewer digits. MINVALUE must be less than or equal to START WITH and must be less than MAXVALUE.

 CREATE SEQUENCE supplier_seq
 MINVALUE 1
 MAXVALUE 999999999999999999999999999
 INCREMENT BY 1;

Related questions

Best way to reset an Oracle sequence to the next value in an existing column?

For some reason, people in the past have inserted data without using sequence.NEXTVAL. So when I go to use sequence.NEXTVAL in order to populate a table, I get a PK violation, since that number is already in use …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More
How to insert date values into table

How can I insert into table with different input using / ,with date datatype? insert into run(id,name,dob)values(&id,'&name',[what should I write here?]); I'm using oracle 10g.

Read More