Randomise Date Column

This is a useful statement for when you need help randomizing your date data for testing purposes. In this case, I’m assuming you’ve inserted a certain amount of test data into your table but it’s all showing the same date. First of all: temporarily disable any triggers that you have that will affect this table. Modify this statement to fit your needs: update TABLE_NAME set … Continue reading Randomise Date Column

PL/SQL Delay

I had an app to demonstrate where I had built an autonomous scheduled status checker with customer communication generated on certain status changes. This is a very difficult thing to demonstrate without letting the 24-hour cycle run its course. Unfortunately, people get bored of waiting for status changes and want you to speed things up. To accommodate this, I wanted to “fake” the schedule by … Continue reading PL/SQL Delay