No support for SQL functions—B-tree indexes are not able to support SQL queries using Oracle's built-in functions. Oracle9i provides a variety of built-in functions that allow SQL statements to ...

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.