Ido Montekyo

Photo by Jess Bailey on Unsplash

I have an Oracle database table with 101 Monday Motivation Quotes and I would like my app to randomly pick and display a quote on the homepage.

What is the easiest way to select a random record from an Oracle database table?

The following will result in one random record:

SELECT q.text FROM quotes q ORDER BY DBMS_RANDOM.value FETCH NEXT 1 ROWS ONLY;
TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
-----
"Start where you are. Use what you have. Do what you can." - Arthur Ashe

The quotes can be found on the positivity blog

“A ship is always safe at shore but that is not what it’s built for.”
– Albert Einstein

🍕

--

--

TigerVNC

Virtual Network Computing (VNC) is a graphical desktop sharing system that uses the Remote Frame Buffer protocol (RFB) to remotely control another computer. It transmits the keyboard and mouse input from one computer to another, relaying the graphical-screen updates, over a network.

Which VNC viewer/client can I use on macOS?

There are several VNC clients for macOS. Most of which are not free. However, TigerVNC is free and can be downloaded via their page on GitHub. The current version can be downloaded from here.

TigerVNC was originally based on the (never-released) VNC 4 branch of TightVNC. More information regarding the motivation for creating this project can be found in the project announcement.

Important note: the version which is installed via homebrew E.g. “brew install tiger-vnc” did not work well for me. So, I highly recommend installing manually and not via homebrew

--

--

Photo by Sam Pak on Unsplash

I often use my MacBook as a sandbox using Docker Containers. When it starts looking like ground zero, That’s when I need to delete everything!

Step 1 — Stop all running containers

docker kill $(docker ps -q)

Step 2 — Docker system prune

docker system prune --all --force --volumes

This will delete all containers, volumers and images

Step 3 — Check inventory

➜ docker ps
CONTAINER ID…

--

--

Ido Montekyo

Ido Montekyo

System Analysis. System Design. Architecture. Databases. Project Management. Speaker. People Motivator.