How to Install SQLplus on MacOS?

Oracle database is the most commonly used database in transaction processing, data warehousing, and several other applications. SQLPlus is the basic Oracle Database utility and the main purpose of this module is to interact with the Oracle database and run different types of queries. It is the most commonly used Python module and allows you to analyse data without learning Pandas and SQL. In this article we will learn how to install SQLplus on macOS step by step.

Installing SQLplus on MacOS

Method 1: Using pip to install SQLplus Package

Follow the below steps to install the SQLplus package on macOS using pip:

Step 1: Install the current version of Python3 in macOS

Step 2: Check if pip3 and python3 are correctly installed in the system with the help of following commands:

python3 --version

pip3 --version

Step 3: Upgrade pip to avoid getting errors during installation process.

pip3 install --upgrade pip

Step 4: Enter the following command to install SQLplus using pip3.

pip3 install sqlplus

Method 2: Using setup.py to install SQLplus

Follow the below steps to install the SQLplus package on macOS using the setup.py file:

Step 1: Download the latest source package of SQLplus for python3 from here.

curl https://files.pythonhosted.org/packages/ac/ae/ca0cf3943b3021e68bd7e79201a66119cbf1bc43adcfc3575234cf4d6243/sqlplus-2.6.5.tar.gz > sqlplus.tar.gz

Step 2: Extract the downloaded sqlplus package using the following command.

tar -xzvf sqlplus.tar.gz

Step 3: Go to the sqlplus-2.6.5 folder and enter the following command to install the package.

cd sqlplus-2.6.5

python3 setup.py install

Note: You must have developer tools for XCode MacOS installed in your system

Verifying SQLplus installation on macOS

To verify the SQLplus is installed successfully or not we import this package in Python terminal. If it is not installed properly then you will get errors.

import sqlplus