Creating a sequence to start with 1

Posted by Phindile on Jan 12, 2018; 11:15am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Creating-a-sequence-to-start-with-1-tp4898.html

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.