Selecting the Next available Sequence number in PL/SQL

The Dual table is a special table that exists in oracle, it keeps track of sequence information for you. You can query it to return the next number in your sequence like this:

Select CustomerID_SEQ from Dual;

from Abstractvb.com