DevOps, CI/CD and Automation

Hello All,

I'm having trouble figuring a way to convert the row returned from a basic execute statement into a named tuple/Dictionary.

The idea, is to be able to access each field via row['column_name']. I'm currently looking at creating a factory, but still a complete noob to python and cx_Oracle.

cur.execute(""SELECT * FROM V$INSTANCE""")
#print 'Query Executed..'
row = cur.fetchone()
#print 'Cursor Loaded.'
#print result[0], result[1]
list = {}
list['host_name'] = row['host_name']
print row['host_name']

Thanks in advance for your assistance.

Jan S.