How To Install sqlcl-package on Ubuntu 20.04

In this tutorial we learn how to install sqlcl-package on Ubuntu 20.04. sqlcl-package is Oracle SQL Developer Command-Line Debian package builder

Introduction

In this tutorial we learn how to install sqlcl-package on Ubuntu 20.04.

What is sqlcl-package

sqlcl-package is:

This utility makes it possible to build a Debian package from Oracle SQL Developer Command-Line (SQLcl). The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility to use the resulting package accordingly with the OTN license, a copy of which is included in the created package, that you must agree on when downloading the source.

This utility will require you to download the architecture independent archive from http://www.oracle.com/technetwork/developer-tools/sqlcl/overview, identified as “Oracle SQL Developer Command-Line for All Platforms”, to create the Debian package from.

Due to a conflicting name with content of package “parallel” the upstream binary “sql” will be renamed. Multiple versions can coexist so “sql.[upstream version].standalone” will invoke a specific version of Oracle SQL Developer Command-Line, “sql.[upstram version]” will invoke either the standalone or bundled Oracle SQL Developer Command-Line version (in this order), while “sqlcl” (the recommended way) and “sqlcl.standalone” take advantage of Debian’s alternatives system and, when left in auto mode, will always invoke the highest version installed.

There are three methods to install sqlcl-package on Ubuntu 20.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install sqlcl-package Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install sqlcl-package using apt-get by running the following command:

sudo apt-get -y install sqlcl-package

Install sqlcl-package Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install sqlcl-package using apt by running the following command:

sudo apt -y install sqlcl-package

Install sqlcl-package Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install sqlcl-package using aptitude by running the following command:

sudo aptitude -y install sqlcl-package

How To Uninstall sqlcl-package on Ubuntu 20.04

To uninstall only the sqlcl-package package we can use the following command:

sudo apt-get remove sqlcl-package

Uninstall sqlcl-package And Its Dependencies

To uninstall sqlcl-package and its dependencies that are no longer needed by Ubuntu 20.04, we can use the command below:

sudo apt-get -y autoremove sqlcl-package

Remove sqlcl-package Configurations and Data

To remove sqlcl-package configuration and data from Ubuntu 20.04 we can use the following command:

sudo apt-get -y purge sqlcl-package

Remove sqlcl-package configuration, data, and all of its dependencies

We can use the following command to remove sqlcl-package configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge sqlcl-package

References

Summary

In this tutorial we learn how to install sqlcl-package package on Ubuntu 20.04 using different package management tools: apt, apt-get and aptitude.