[cx-oracle-users] How to perform a subquery??
Brought to you by:
atuining
From: Eduardo N. <ed...@gm...> - 2015-10-06 20:25:54
|
## Performs connected query and results by sending e-mail import smtplib import cx_Oracle con = cx_Oracle.connect('edu/edu@129.129.128.129/sample') cursor = con.cursor() cursor.execute(file('C:\QUERY.sql').read()) rs = cursor.fetchall() print(rs) smtpObj = smtplib.SMTP_SSL('mail.labtec.com',465) smtpObj.ehlo() smtpObj.login('mo...@la....','xxxx') smtpObj.sendmail('mo...@la...','ed...@la...',str(rs) ) smtpObj.quit() |