Search notes:

cx_Oracle and SQLAlchemy

import sqlalchemy
import os
import pandas
 
db_user = 'rene'
db_pw   = 'xxx'
db_env  = 'oradb'
 
eng = sqlalchemy.create_engine(f'oracle+cx_oracle://{db_user}:{db_pw}@{db_env}')
 
with eng.connect() as con:
     df = pandas.read_sql_query(sqlalchemy.text('select object_name, object_type txt from user_objects'), con)
     print(df);

See also

cx_Oracle

Index