Connor loves SQL , 🍸and ☕️(@connor_mc_d) 's Twitter Profileg
Connor loves SQL , 🍸and ☕️

@connor_mc_d

Hi I'm Connor McDonald!

🔥keen on tech esp. SQL/database
🔥keen on fitness
🔥keen on coffee
🔥keen on gin
🔥keen on sarcasm

I speak for me not my employer

ID:22357380

linkhttps://linktr.ee/connor calendar_today01-03-2009 12:12:29

26,8K Tweets

15,5K Followers

538 Following

@APEX/JeffreyKemp.sql(@jeffreykemp) 's Twitter Profile Photo

Some tidbits of knowledge well worth storing away in the noggin - remote dependencies mode (useful if you use dblinks), etags (useful for optimistic locking) youtube.com/watch?v=mXnxtO…

account_circle
Connor loves SQL , 🍸and ☕️(@connor_mc_d) 's Twitter Profile Photo

'We rewrote the logic in SQL, which was surprisingly simpler compared to the previous code'

Sooner or later, people that thought dealing with data in a programming language was a good idea ... realise that SQL is the only way to go.

canva.dev/blog/engineeri…

account_circle
SQL Daily(@sqldaily) 's Twitter Profile Photo

Using LAST_DDL_TIME in *_OBJECTS to check when an object in Oracle Database was last changed?

Note:

Changing an index can also update the table's LAST_DDL_TIME
For partitioned indexes and tables, check the time at the object level

Connor loves SQL , 🍸and ☕️ demos youtube.com/watch?v=OCeRAX…

account_circle
Connor loves SQL , 🍸and ☕️(@connor_mc_d) 's Twitter Profile Photo

If you want just the right amount of audit trail in the database...not too much, not too little, then 23c has you covered.
youtu.be/wLg-GgVBT08

account_circle
Connor loves SQL , 🍸and ☕️(@connor_mc_d) 's Twitter Profile Photo

Snapshot standby is one of the hidden gems of DataGuard.

And you can get it on Autonomous as well!
docs.oracle.com/en-us/iaas/aut…

account_circle