python 使用cx_oracle

python 模块方法

---

cx_oracle

#引入模块
import cx_Oracle
#创建连接
connects = cx_Oracle.connect('innpay/innpay@orcl')
#打开游标
cursors = connects.cursor()
#定义一条SQL
workdate_sql = '''select cdate from work_day t
where
--截止当天最后一个工作日最早的一个工作日
t.cdate >=
(select max(cdate) from work_day t where t.work = 'Y' and t.cdate <
(select min(cdate) from work_day t