I think u didn't get dat ..i meant to say IF I am taking one additional column in my table where I need to assign one column a sequence ..Is there any function available in plsql...to do that