Installing modern SQLCL shell at NSU

setup_sqlcl.sh

#!/bin/bash

# Navigate to home directory
cd ~

# Create a 'downloads' directory in the home directory
mkdir -p ~/downloads

# Navigate to the 'downloads' directory
cd ~/downloads

# Download sqlcl zip file
curl -O https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-21.4.1.17.1458.zip

# Unzip the downloaded file
unzip sqlcl-21.4.1.17.1458.zip

# Navigate back to home directory
cd ~

# Download the sqlcl.sh script
curl -O https://gist.githubusercontent.com/airstrike/1970aa5a02eac204d01411ff75592f31/raw/107de9eaaf247192345aedf29bec43aa7d94bfdc/sqlcl sqlcl.sh

# Make the sqlcl.sh script executable
chmod +x ~/sqlcl.sh

# Append `sqlcl` alias to .bash_profile
echo 'alias sqlcl="$HOME/sqlcl.sh"' >> ~/.bash_profile

Here's a link to the other gist which contains the sqlcl script I linked directly in the above script (i.e. I'm curl'ing the raw version of that script so you don't have to copy-and-paste it):

https://gist.github.com/airstrike/1970aa5a02eac204d01411ff75592f31