Yes, you can do that query in 9i (with and without the CURSOR statement)