Column names you should NOT use
We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good
Tag: development
PL/SQL in 21c gets amazing new loop iterators
“It’s a dead language” people said. “There’s never anything new” people said. Well, let me serve those people a slice
SQL tuning with Hashing and Sorting
Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that
Completely free training for Oracle novices
At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database
How to generate random unique values
When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique
Getting a dog improved my productivity
Today’s blog post is somewhat of a different one. You could perhaps argue that it is even non-technical but bear
Code re-use in PL/SQL might just need SQL
I was doing some code review today of a PL/SQL package, and came across a routine to generate a list
Oracle Code … Not for database people ?
Jump over to the Oracle Code home page and you will see the “mission statement” of the Oracle Code conference
Learning is not a spectator sport 