Databases
Oracle
Databases
Oracle
This is the implementation of the Oracle data handler for MindsDB.
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation.
Implementation
This handler is implemented using the oracledb
library. Please install it with the below command before using this handler.
pip install oracledb
The required arguments to establish a connection are as follows:
host
is the host name, IP address, or URL.port
is the port used to make TCP/IP connection.sid
is the unique identifier of the database instance.user
is the database user.password
is the database password.
Usage
In order to make use of this handler and connect to the Oracle database in MindsDB, the following syntax can be used:
CREATE DATABASE oracle_datasource
WITH
ENGINE = 'oracle',
PARAMETERS = {
"host": "127.0.0.1",
"port": 1521,
"sid": "ORCL",
"user": "sys",
"password": "password"
};
The connection accepts either sid
or service_name
arguments to target the right database instance.
You can use this established connection to query your table as follows:
SELECT *
FROM oracle_db.my_table;