[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()
|