Chris Saxon's Recent LinkedIn Posts

Change an Oracle table to be insert-only with ALTER TABLE ... BECOME IMMUTABLE NO DROP ... NO DELETE ... This then blocks UPDATEs to the rows You can only remove - rows older than the NO DELETE setting - the table if there's no new rows since the NO DROP setting

Compiling PL/SQL packages with global vars causes: ORA-04068: existing state of packages has been discarded in other sessions accessing the package Even if the functions don't rely on state! Avoid this by declaring packages RESETTABLE To auto-rerun package initialization

ICYMI: Oracle AI Database 26ai Free 23.26.3 is now available Download it at https://lnkd.in/eFYWA4E3 There are lots of security fixes in this RU - I strongly recommend you get this whatever you use Free for. There are also a few #SQL features - DATEADD is great for simplifying date logic

The maxim to avoid WHEN OTHERS THEN NULL in PL/SQL is good but, as I've learned, incomplete. I've just spent far too long investigating an issue in a procedure with this exception handler: EXCEPTION   WHEN DUP_VAL_ON_INDEX THEN NULL;   WHEN OTHERS THEN log ( ... ); I saw the logging call, so kept wondering why t…

Think you know about #SQL performance? Take this 3-minute indexing quiz by Markus Winand A simple test that 60% fail! https://lnkd.in/ejRx5pbn Did you pass? Let us know how you did!

Compiling PL/SQL packages with global vars causes: ORA-04068: existing state of packages has been discarded in other sessions accessing the package Even if the functions don't rely on state! Avoid this by declaring packages RESETTABLE To auto-rerun package initialization