Multiple Recordsets

I am working with ado and oracle. CursorLocation = adUseclient. I need to use multiple recordsets. Can someone help me how to work with multiple
recordsets? Are there any good books out there? Thanks a lot for any help on this. Christa