I 've a following query that going to use in python api.
SELECT n.FIRST_NAME as "NAME", a.STREET_1 as "ST1", a.STREET_2 as "ST2" FROM SCHE.EMPLOEE_NAME n, SCHE.EMPLOYEE_ADDR a
WHERE n.eid=a.eid
AND n.estatus='ACTIVE'
The above query yields the result
cursor().execute(sqlQuery)
sqlTupleRows=cursor().fetchall();
sqlQueryReturnedDict={};
for sqlTupleRow in sqlTupleRows:
columns=cursor().description
......
Here the column names returns as ('NAME','ST1','ST2') instead of ('FIRST_NAME', 'STREET_1', 'STREET_2'), but I need to fetch column names as it is from database table what we used in query rather than alias, how do we fetch taht information?