python----运用Oraclej基本句型

# coding:utf-8
importcx_Oracle
conn=cx_Oracle.connect('vms/abc#2012aug@VMS.dbsit.sfdc.com.cn/vmssit')
curs=conn.cursor ()
sql='select rowid,a.*from TS_VMS_ALARM_EMAIL a where a.alarm_class=15'
rr=curs.execute(sql)
row=curs.fetchone()
whilerow:
(DEPT_ID,EMAIL) = (row[0],row[5])
row = curs.fetchone()
printDEPT_ID,EMAIL

#插入多行
curs.execute ("INSERT INTO TEST123 (ID, COL1, COL2, COL3)VALUES(4, 'ab', 'bc', 'cd')")
curs.execute ("INSERT INTO TEST123 (ID, COL1, COL2, COL3)VALUES(5, 'aab', 'bbc', 'ccd')")
curs.execute ("INSERT INTO TEST123 (ID, COL1, COL2, COL3)VALUES(6, 'aaab', 'bbbc', 'cccd')")
conn.commit()

#打印
curs.execute("select*from TEST123")
rows = curs.fetchall()
forrowinrows:
print"%d,%s,%s,%s"%(row[0],row[1],row[2],row[3])
print"Number of rows returned:%d"%curs.rowcount
'''
curs.execute("select ID,COL1,COL2,COL3 from TEST123")
while 1:
row = curs.fetchone()
if row == None:
break
print ("%d,%s,%s,%s"%(row[0],row[1],row[2],row[3]))
print "Number of rows returned:%d" % curs.rowcount

result = curs.fetchmany(3)
count = curs.rowcount
print "Total:",count
print "======="
for row in result:
print row
'''
curs.close ()
conn.close ()