Application Express – the PSE update
I published a post a couple of days ago about how due to the architecture of PL/SQL and hence Application
Updating my APEX 20.2 installation
One of (or should I say “another of”!) the very cool features of Application Express (APEX) is that by being
Math and SQL: Two of my favourite things
There has always been a special place in heart for the Fibonacci sequence. Decades ago in high school when comparing
APEX 20.2 comes to town (well, to my PC)
As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be
The weirdest reason to avoid SELECT *
A quick Google or Bing search and you’ll find no limit to the number of articles on databases that tell
Why you keep getting "ORA-01653: unable to extend table"
Space management used to be hard Way back in the good old days…In fact, before I continue, rest assured that
Compression default settings
If you are loading a data warehouse or similar environment where your default approach would probably be to compress all
When can I use SQL Macros?
One of the very cool features we’ve been talking about for 20c is SQL Macros. But you no longer need
Age calculations – Just how old ARE you?
Any database application that stores information about people will very likely store a person’s date of birth as part of
The CEIL function, dates and floating point numbers
Oh yes indeed, I have dug deep into the well of cheesy blog post titles for this one . But
