Capital inflow into Nigeria's oil sector has dropped by more than 82 percent in the second quarter of 2022.