There are more rows in that table.
It's one that we use for storing sequential numbers we use... like invoice
numbers, membership numbers etcetc
So we have to lock row when using it, so noone else uses the same number
when we add a new member or
create a new invoice...
But good advice tho, and
you need a where clause on that select statement, so that you get the
ONE row in that table that you want.
and remove the nowait. Nowait tells Oracle to continue processing the
next statement even if you didn't get the lock you wanted... Of course
removing it has it's own drawbacks, you could be