【python】操作oracle数据库
# -*- coding: utf-8 -*-import cx_Oracle
conn = cx_Oracle.connect('user/pass@IP/datebase')
cursor = conn.cursor()
sqlcmd = '''
select * from test
'''
cursor.execute(sqlcmd)
rows = cursor.fetchall()
#row = cursor.fetchone()
for row in rows:
print (row, row, row, row)
cursor.close ()
conn.close ()
页:
[1]