For those of use who like to learn and experiment, sample data is a must.
In this post, I’m linking to and summarising some sample data sets which are shared with licenses allowing people to use and reuse them with a lot of freedom.
If you only want to run something quickly, you probably want an online platform that provides a convenient environment for writing, executing, and sharing SQL queries. Here I compare some for use with Oracle SQL & PL/SQL
Here is a quick look at number sequences, which are a brilliant (and fairly database neutral) method to create numbers (and rows) to build datasets from. While working on the dates articles, I used number sequences a lot and thought they were worth coming back to. What is a number sequence A number sequence can…
A data set of continuous dates is useful for cursors and creating date tables. Here I look at ways to produce a list of dates. Continuing my series of posts about dates, I wanted to post something which feeds into lots of examples and testing cases I use day to day in development. I’ll also…