3.14.1. Using Query Hints with Oracle

Oracle has support for "query hints", which are formatted
comments embedded in SQL that provide some hint for
how the query should be executed. These hints are usually
designed to provide suggestions to the Oracle query
optimizer for how to efficiently perform a certainly query,
and aren't typically needed for any but the most intensive
queries.

For VARCHAR fields, null
and a blank string are equivalent. This means that
an object that stores a null string field will
have it get read back as a blank string.

Oracle corp's JDBC driver for Oracle has only limited
support for batch updates. The result for Kodo is
that in some cases, the exact object that failed an
optimistic lock check cannot be determined, and Kodo
will throw an OptimisticVerificationException with
more failed objects than actually failed.

Oracle cannot store numbers with more than 38 digits
in numeric columns.