developer – Page 3 – Learning is not a spectator sport

Enforcing DEFAULT values

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our

So I tweeted this out on Friday and this reflects one of my joys with working with Oracle technology. The

No topic quite gets emotions rolling as much as the Oracle Query Optimizer. The fact that a piece of software

Just a quick word of warning on a cool feature of SQL*Plus that came along from 18c onwards. I’ve posted

Security eh? It is just one of those little things that is good to have in a database. The “problem”

Just a re-post of something I put on StackOverflow last year so I can refer back to it easily. What

I published a video a few days ago on the various tools you can use to unload data out of

In last weeks’ Office Hours session, I posted an “impossible” challenge to two of the most well credentialed Oracle community

A phrase I’ve often used when discussing database design is “insurance policy”, namely, when I talk about adding CHECK constraints,