uSometimes
it is just not possible to represent all required functionality in a
single SQL statement.
uDenormalized
view cannot be built.
uOracle
provides a different mechanism:
ØCollections allow you to hide the data separation, as well
as all of the transformation logic.