可以的

# coding: utf-8


import dmPython

try:
    conn = dmPython.connect(user='SYSDBA', password='SYSDBA', server='localhost', port=5236)
    cursor = conn.cursor()
    info = cursor.execute("""select * from dba_tab_cols where OWNER='SYSDBA' and TABLE_NAME='PRODUCT';""")
    for i in info:
        print(i)
    conn.close()
except (dmPython.Error, Exception) as err:
    print(err)