oracle provider: fix subquery support (fixes #10694)