Install SQL developer

Get Oracle SQL Developer package

1. go to Homepage: http://www.oracle.com/technology/software/products/sql/index.html
#https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-20.2.0.175.1842-no-jre.zip
#https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-19.2.1.247.2212-no-jre.zip
2. accept the licence
3. login
4. download "Oracle SQL Developer for other platforms"
# download sqldeveloper-*-no-jre.zip archive
 
# extract
sudo unzip -q sqldeveloper-*-no-jre.zip -d /opt/
 
# Create desktop starter
cat <<EOF | tee /usr/share/applications/sqldeveloper.desktop
[Desktop Entry]
Encoding=UTF-8
Name=Oracle SQL Developer
Exec=/opt/sqldeveloper/sqldeveloper.sh
Icon=/opt/sqldeveloper/icon.png
Terminal=false
Type=Application
Categories=GNOME;Application;Development;
EOF
 
# configure JDK home
grep Home ~/.sqldeveloper/20.2.0/product.conf
SetJavaHome /usr/lib/jvm/java-8-oracle/

# DEP:
https://raw.githubusercontent.com/panticz/installit/master/install.sqldeveloper.sh

# reduced memory usage
sed -i 's|-Xmx640M|-Xmx384M|g' /opt/sqldeveloper/ide/bin/ide.conf