===== Oracle Instant Client =====
==== Installation ====

<code>
sudo apt install -y libaio1
mkdir oracle && cd "$_"

wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip
wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip

unzip instantclient-basic-linux.x64-23.7.0.25.01.zip
unzip instantclient-sqlplus-linux.x64-23.7.0.25.01.zip

export LD_LIBRARY_PATH=$PWD/instantclient_23_7:$LD_LIBRARY_PATH
export PATH=$PWD/instantclient_23_7:$PATH
</code>

==== Easy Connect using SQL Plus ====
=== With Password ===

<code>sqlplus user/password@host:port/db_service_name</code>
The port number does not need to be specified if it is 1521\\

=== Without Password ===
If using the bash shell you may get an error if you do not wish to type the password on the command prompt.\\
In this case you need to quote your connect string and escape the quotes with backslashes.\\

<code>sqlplus user@\"host:port/db_service_name\"</code>