On the oscillatory behavior of singular Sturm-Liouville expansions