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
Tag: sql
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
Developer Live wrap up
The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across
Faster DISTINCT operations in 19c
If I gave you a telephone book and asked you to tell me how many distinct street names are present
How to TREAT data in a CLOB as JSON
What better way to start a new week than with a cheesy title to my blog post! But there is
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
GROUP BY better than DISTINCT for materialized views
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the
Listener log data mining with SQL
If you take a look at the log files created by the listener, there is obviously a nice wealth of
The holistic SQL tuning series
I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I
