Login  Register

Creating a sequence to start with 1

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

Creating a sequence to start with 1

Phindile
25 posts
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
| More
Print post
Permalink

Re: Creating a sequence to start with 1

ErmanArslansOracleBlog
Administrator
5731 posts
Random?
Weird.

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