Skip to Main Content

General Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

November 19, 2020

13:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Answering all of your questions
In this Office Hours session we discussed:

- How to compare large data sets efficiently
- How to achieve massive performance even when you need to lock critical resources for serialisation
- The anomaly of DML error logging versus triggers on the underlying tables
- How to avoid SQL injection with the new SQL Macro features in 19c
- Why pipelined functions might slow down even if the SQL within them is fast

Your Experts

    Connor McDonald

    Connor McDonald   

    Connor McDonald is a former Oracle ACE Director who has joined the Oracle Developer Advocates Team. He has co-authored three books, is a popular speaker at Oracle conferences around the world, and is best known as a member of the AskTOM team.