im using oracle 9i and my query for increase the id is
nz(max(asset_id),0) + 1 its incorpated into my insert statement.