python与oracle（二）常用方法

>>> orcl116=cx_Oracle.connect("gisinfo/gisinfo@orcl")#连接数据库
>>> curs=orcl116.cursor()#建立游标
>>> curs.execute("select id from wlgt where rownum<10")#执行语句
>>> curs.fetchmany(10)#获取多行，超过返回剩余行
[(10070000237397L,), (10070000237398L,), (10070000237399L,), (10070000236839L,),
 (10070000240333L,), (10070000237400L,), (10070000238565L,), (10070000238566L,),
 (10070000238567L,)]
>>> curs.fetchmany(4)#获取部分
[(10070000237397L,), (10070000237398L,), (10070000237399L,), (10070000236839L,)]
>>> curs.fetchmany()#获取所有
[(10070000237397L,), (10070000237398L,), (10070000237399L,), (10070000236839L,),
 (10070000240333L,), (10070000237400L,), (10070000238565L,), (10070000238566L,),
 (10070000238567L,)]
>>> pprint(curs.fetchone())#获取一行
(10070000237397L,)
>>> from pprint import pprint#导入pprint模块从pprint脚本中
>>> pprint(curs.fetchall())#打印
[(10070000237397L,),
 (10070000237398L,),
 (10070000237399L,),
 (10070000236839L,),
 (10070000240333L,),
 (10070000237400L,),
 (10070000238565L,),
 (10070000238566L,),
 (10070000238567L,)]
>>> curs.execute("select wlgtid from wlgt where rownum<10")
<__builtin__.OracleCursor on <cx_Oracle.Connection to gisinfo@orcl>>
>>> list(curs)#效果同execute
[(10070000237397L,), (10070000237398L,), (10070000237399L,), (10070000236839L,),
 (10070000240333L,), (10070000237400L,), (10070000238565L,), (10070000238566L,),
 (10070000238567L,)]