Recently I needed to perform some housekeeping on a Windows folder. Part of this work required that the filenames be in lowercase. I know, in a usually case insensitive Operating System but bear with me. A search found this answer on Stackoverflow. dir <<YOUR FOLDER HERE>> -r | % { […]
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 […]
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 […]
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 […]
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 […]
