Re: How do you use Aliases?
"Fawcett, David (MNIT)" <[email protected]> Tue, 9 Jun 2015 21:27:29 +0000
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <D645DD294B659443AAFDEFBEC8F1E9821443A30C@055-CH1MPN1-001.055d.mgd.msft.net> |
Have you tried 'SELECT EMPLID AS UID FROM TABLE WHERE EMPLID=:emplid' From: Jay [mailto:[email protected]] Sent: Tuesday, June 09, 2015 3:49 PM To: [email protected] Subject: [cx-oracle-users] 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