So far we have been using the dialect org.hibernate.dialect.Oracle9Dialect
for hibernate.dialect property for all Oracle versions (10g/11g). We plan
to use Oracle12c as well. Our initial tests indicate that continuing with
Oracle9Dialect for Oracle12c will work. Does anyone have any suggestions/
recommendations/use cases where we would need to use a different dialect for
Oracle12c while maintaining backward compatibility with earlier Oracle versions
(10g/11g) ?

It would be great if some one can point me to an existing wiki/documentation
which I might have missed on oversight.