How do you use Aliases?

Trying to use an alias with cx_Oracle and nothing I'm trying seems to work:

cursor.execute('SELECT EMPLID "UID" FROM TABLE WHERE EMPLID=:emplid',
{'emplid':'123456'}):

fails with:

cx_Oracle.DatabaseError: ORA-00923: FROM keyword not found where expected

I've tried every way I can find on the internets to quote/insert that
Alias, but nothing seems to work. All I'm trying to do is alias EMPLID as
UID.

Is this just something that can't be done with this driver?? or Python? or??

-= Jay =-

------------------------------------------------------------------------------

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users