ANSI catalogue

This is a list of articles I’ve written that pick up some detail about using features of the ANSI syntax that are (or were) less commonly used in traditional Oracle SQL.Each entry has a date stamp and a short note of the contents. The articles are generally listed most-recent first.

• Join view delete (May 2022): ANSI expansion problems with deletes from join views
• Cursor_sharing anomaly (May 2016): Problems with DATE and TIMESTAMP constants.
  • Cursor sharing update (Oct 2019): Rediscovery and further comment on the above