How you build your test cases directly impacts the chances of someone helping you
---
RT @connor_mc_d
Been a bit tardy on blogging so time to jump back on the horse! Enjoy! #database #sql
https://connor-mcdonald.com/2023/05/02/can-you-pass-the-empty-schema-test/
https://twitter.com/connor_mc_d/status/1653364524655714307

23c continues to get better and better
---
RT @connor_mc_d
Fresh video!
Now when your applications update data they can get both the previous and new values for the columns in a single trip to the database, all with a simple extension to the existing syntax.
#database #sql
https://www.youtube.com/watch?v=a_4Puge8hMw
https://twitter.com/connor_mc_d/status/1653087347725025292

RT @connor_mc_d
Wrapping up Norway with a tip to other event organizers on logistics, the ACE program and something ominously threatening at the very end of this video :-) #ougn2023 @oracleace

LOTS of columns available for you in 23c
---
RT @connor_mc_d
Fresh video!
It's not for every table and every application, but more columns can be useful in special cases
#database #sql
https://youtu.be/7KS7cN2ZMwQ
https://twitter.com/connor_mc_d/status/1651830100797841409

Join us, we will be live soon! Office Hours session: OML Services Batch Scoring on Autonomous Database starts in 65mins https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:6801 #oracle #AskTOMOfficeHours

Join us and learn! Next session for Oracle AskTOM Office Hours: Low-Code for building an automated clinical trial oversight system - a customer story. Starts on 19 April at 15:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:19665 #oracle #AskTOMOfficeHours

RT @connor_mc_d
VALUES clause.
Now with less code, and more flexibility!
#database #sql
https://youtu.be/fKTb6CfPxCk

Next week: Spatial for Python developers. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 25 April at 14:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:7761 #AskTOMOfficeHours

Next week: Multicloud Happenings!. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 25 April at 14:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:19662 #AskTOMOfficeHours

Often viewed on #AskTOM: Export into pre-existing schema https://asktom.oracle.com/pls/apex/asktom.search?tag=export-into-pre-existing-schema

London calling to the IT folks in town
---
RT @oracledatabase
Join Oracle #DatabaseWorld London on April 20 at the Intercontinental Hotel - The O2 for expert-led talks, hands-on labs, and a preview of the next release of the #OracleDatabase by the PMs and developers. This FREE one-day event is open to everyone.
https://social.ora.cl/6016O3F64
https://twitter.com/OracleDatabase/status/1647944847108571136

The recording for the Office Hours session: Secure Oracle Database connections with one-way Transport Layer Security (TLS) is available. https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:20408 #AskTOMOfficeHours

Coming up: OML Services Batch Scoring on Autonomous Database. Oracle experts will be online for AskTOM Office Hours. Next session starts 18 April at 15:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:6801 #oracle #AskTOMOfficeHours

Often viewed on #AskTOM: Relation between SCN and checkpoint SCN https://asktom.oracle.com/pls/apex/asktom.search?tag=relation-between-scn-and-checkpoint-scn

Next week: Database Backup and Recovery. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 21 April at 16:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:1341 #AskTOMOfficeHours

RT @connor_mc_d
We've made using the GROUP BY clause so much easier in 23c...But you need to know about the special parameter to unlock it!
#database #sql
https://youtu.be/dcMBwVwjZGE

Often viewed on #AskTOM: datafile block fractured https://asktom.oracle.com/pls/apex/asktom.search?tag=datafile-block-fractured

The recording for the Office Hours session: JSON Relational Duality Views is available. https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:20406 #AskTOMOfficeHours

#AskTOM Just answered: Conditional unique basing upon existing data http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9547449400346575418

Next week: Part 1: What's new in Oracle APEX 23.1. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 20 April at 14:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:744 #AskTOMOfficeHours