1、安装cx_Oracle
python -m pip install cx_Oracle
2、连接
db = cx_Oracle.connect('user','passwd','192.168.0.77:1521/orclpdb')
3、生成cursor
cursor= db.cursor()
4、执行sql
rows.cursor.execute('select count(1) from user_tables') ;
5、读取结果
rows.fetchall()
1、安装cx_Oracle
python -m pip install cx_Oracle
2、连接
db = cx_Oracle.connect('user','passwd','192.168.0.77:1521/orclpdb')
3、生成cursor
cursor= db.cursor()
4、执行sql
rows.cursor.execute('select count(1) from user_tables') ;
5、读取结果
rows.fetchall()