oracle 绑定变量用法,cx_Oracle模块学习之绑定变量 | 学步园

有些时候我们需要和程序交互，此时需要绑定量

下面两个例子简介在SELECT 和 DML 里面绑定变量的用法

SELECT 里面的绑定变量

[root@Ora10G py]# cat SelectBinding.py

#!/bin/env python

#coding=utf-8

#filename:execise binding in select

#Author:DBA_WaterBin

import cx_Oracle

conn=cx_Oracle.connect('hr/hr@orcl')

cur=conn.cursor()

dept_id=raw_input('\n please input department ID you want to search:')

dept_name=raw_input(' please input department name you want to seaarch:')

cur.execute('''select * from departments

where department_id=:id and

department_name=:name

''',id=dept_id,name=dept_name

)

rows=cur.fetchall()

print '\ninformation are as following:'

for row in rows:

print row

cur.close()

conn.close()

DML 里面的绑定变量

[root@Ora10G py]# cat DmlBinding.py

#!/bin/env python

#coding=utf-8

#filename:execise binding in dml

#Author:DBA_WaterBin

import cx_Oracle

conn=cx_Oracle.connect('hr/hr@orcl')

cur=conn.cursor()

cur.execute('''insert into departments (department_id,department_name,manager_id,location_id)

values(:ID,:NAME,:MGR_ID,:LOC_ID)

''', {'ID':555,'NAME':'WaterBin','MGR_ID':110,'LOC_ID':7788}

)

cur.close()

conn.commit()

conn.close()

By DBA_WaterBin

2013-09-09

good luck