oracle conn

import cx_Oracle

import pandas as pd

connection = cx_Oracle.connect("user","pwd", cx_Oracle.makedsn("server",1521,"database"))

result= pd.read_sql_query('select * from ABC ', con=connection)

connection.close()

Refer to https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for installing cx_Oracle driver