"Big Mac and Size"..Handling large SQL Macros
Happy 2021 everyone! And what better way to start than a cheesy pun to make you groan and already to
Tag: developer
Solving a John Conway puzzle with SQL
A cool little conundrum came across my email Inbox this week which I thought I’d share. Back in 2016, Pizza
The AskTOM multimedia experience!
Most people know AskTOM as the go-to resource for getting answers to the most common and sometimes the most tricky
The power of SQL macros
Here is another example of what I’m sure will just become a plethora of such examples from the community on
The missing multiplication aggregation in SQL
A few days back on Twitter, a cool little discussion arose out of the SQL Daily regular tip – the
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
Developer Live wrap up
The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across
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
Why relying on default DATE formats is a bug
Today’s quick but important message is…don’t be lazy! Look….I get it If given the choice of typing: ’01-JUL-20′ or typing
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
