#rodsays Can we not use the cache? in a PR review. It confused me because I didn't use cache at that place.

Soon I realized that he is actually asking "Can't we use the cache here?"

Though this question confused me, it perfectly makes sense for native speakers. It is just a naughty way to say "Why don't we use cache here" or "We should use cache here."

lol

English is a weird language for English learners.
#english

#rodsays #plsql
Add this:

WHENEVER SQLERROR EXIT ROLLBACK

This means that if your table check generates an ORA-20001 error (or any other sql errors), nothing else will get run. Just in case someone runs the entire script. Without this, it would keep running everything after the error.

#rodsays Always use "TIMESTAMP(6) WITH TIME ZONE". TIMESTAMP does not store time zone information -- it should only be used when the column value is directly tied to a single time zone (e.g. LASTUPDATETIMEINGMT).

#plsql

#rodsays Avoid the use of select * in any new repository code. Explicitly specify the columns you need. This is to avoid problems with the oracle data provider if we change the table structure while the code is running.

#rodsays We should keep generic things truly generic and not to compromise their generic nature under the pretense of adding extensions.