> Cant we select directly from a sequence without having to >use a function? Is there any advantage to using a function? Yes, you can select directly from a sequence. But, they needed a routine that would enable them to specify the sequence name at run-time, not at programming time. That's why the function is being used. -- http://www.freelists.org/webpage/oracle-l