Creating a sequence to start with 1

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Creating a sequence to start with 1

Phindile
Hi Erman,

I've created a sequence like this:

SQL> Create sequence emp_sequence start with 1
increment by 1
minvalue 1
maxvalue 10000;

But then when records are inserted in a table, it does not start with 1. It just starts with a random number.

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Creating a sequence to start with 1

ErmanArslansOracleBlog
Administrator
Random?
Weird.

Send me the output.. I want to see the numbers.