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
Contact Us