A developer doesn't have to write iterations to parse through the object list, but rather get the work done in SQL query format. Till recently, the same wasn't possible for Java developers.

Using Oracle Developer to work on your Oracle SQL database presents you with a functional IDE to write code and check data outputs from queries.

The SQL development environment helps the programmer perform basic functions on supported non-Oracle databases. Developers can browse and execute basic SELECT queries on supported databases.

An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.