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.
Before proceeding, ensure the following prerequisites are met:
This handler is implemented using the oracledb
library. Please install it with the below command before using this handler.
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.The optional arguments are as follows:
disable_oob
defines whether to disable out-of-bank breaks.auth_mode
defines the database privilege mode: SYSDBA, SYSOPER, or others.In order to make use of this handler and connect to the Oracle database in MindsDB, the following syntax can be used:
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: