This is a list of all articles I’ve written that make some comments about things that might be worth remembering when you’re thinking about adding some new functionality to a system. Each entry has a date stamp and a short note of the contents. The articles will generally be listed most-recent first.
I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.
- GTT LOBs (Aug 2021): A note including a reminder that you can associate global temporary tables with a specific temporary tablespace.
- Sequence accelerator (Aug 2021): it’s important to think about the sequence cache size for most versions of Oracle, but an enhancement in 21c allows you to forget about it (almost). Links to a generic 4-part series on sequences written for Simpletalk.
- SQL Table Macros (Aug 2021): a possible alternative to using CTEs (or pipelined functions)
- Generating CSV from SQL*Plus (April 2021): a couple of hints and warnings.
- Finding nearest – a case study (April 2021): lateral views, subqueries and bugs
[…] Design catalogue […]
Pingback by Catalog Catalogue | Oracle Scratchpad — January 29, 2022 @ 6:50 pm GMT Jan 29,2022 |