Enforcing DEFAULT values
Handling default values on columns has been an age old problem that we solved in 12c with extensions to the
Handling default values on columns has been an age old problem that we solved in 12c with extensions to the
I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get
Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means
The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve
Recently I cloned one my (pluggable) databases to a throwaway copy so that I could do some testing of an
Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our
INITRANS defines how many concurrent transactions you can have within a single datablock for a segment (table, materialized view, etc).
For pretty much as long as I can remember, the view V$SESSION_LONGOPS has existed. It has a suite of columns
So I tweeted this out on Friday and this reflects one of my joys with working with Oracle technology. The
One of the toughest problems in database applications is validation of data that extends “across” rows. We have declarative constraints