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);