Question: Do they have
Oracle design patterns, like they do with J2EE design patterns?
Answer:
Oracle does not have design patterns per se, but there are Oracle design
patterns for ancillary features such as Oracle SQL design patterns.
Vadim Tropashko of Oracle Corporation has
a book on SQL design patterns that applies direct to Oracle patterns for SQL.
While this book only covers generic
ANSI SQL design patterns, the concepts apply to Oracle SQL and you can apply the
concepts in Vadim's SQL design patterns to Oracle design patterns.
