You have a few choices:
1) Do the queries one at a time
2) Do the "sort" in your desired order after getting back from the database if using JDBC 3) Sort in Oracle. I think you can define a custom function (which returns your desired order) and sort by that. (I did it in a different database, but I think Oracle supports it too.)