Hi All,
In order to have a unique number for all the employees in emp table i have created a sequence by adding a column ID in emp table and i created a sequence. after generating the sequence i thought of knowing the next value that will be generating in the sequence. So i have written the below query,
select id.nextval from emp1;
i got the output from 15 to 28. In this case when i first generated the sequence the sequence got generated upto 14. But, when i try to access the next val in the sequence it should have given me only 15 as the next value in sequence. Instead it list values from 15 to 28.
Also, in need to know what is the use of cache function while creating the sequence.
Thanks & Regards