Angular Routing: Displaying a spinner

Whilst working through Deborah Kurata’s superb Pluralsight Course on Angular Routing, in module 9 Styling, Animating, and Watching Routes, she mentions if you want the spinner to appear whilst the products are loaded for the product list page you can create a resolver. In this post I show you how I created a resolver for […]

SQLDeveloper: Exporting query results as CSV

This post will show you how to use the SQLFORMAT command from SQL Developer to transform a query output to CSV. Out of the box CSV Enter the following into SQL Developer, I am using SQL Developer version 18.1 and execute it as a script by pressing F5. and here is the output: “EMPLOYEE_ID”,”LAST_NAME”,”SALARY” 198,”OConnell”,2600 199,”Grant”,2600 […]

What is Oracle SQLcl?

SQL Developer Command Line (SQLcl) was introduced in 2016 and is a new Command Line Interface (CLI) for working with the Oracle Database. Why? What about SQL*Plus When compared with SQL*Plus, SQLcl provides a modern way of working on the command line with features such as object completion, inline editing and a history of commands […]

Raspberry Pi: Renaming all file extensions in a directory

In this post I will show you how I used a single line script that I found buried within a comment to a Unix.Stackexchange answer to rename all the file extensions in a directory. The single line script To use, start a new terminal session and change to the directory that were the files reside. […]

Windows Terminal: Setting a background picture

In this post I will show you how you can add a background picture to Windows Terminal. Settings Open Settings either by the keyboard shortcut of CTRL + , or click the down arrow on the Windows Terminal tab bar. The settings, which is a JSON file will be displayed using the editor configured for […]