python oracle

#export ORACLE_HOME=/opt/instantclient_12_1
#export LD_LIBRARY_PATH=$ORACLE_HOME
import cx_Oracle

conn = cx_Oracle.connect('hr/a@192.168.56.101/xe')
cursor = conn.cursor ()
cursor.execute ("select * from jobs")
row = cursor.fetchone ()
print (row )

cursor.close ()
conn.close ()

posted on 2016-09-04 23:43  anjuncc  阅读(131)  评论(0编辑  收藏  举报

导航