python 连接 ORACLE
1. 安装oracle客户端或者oracle软件
自行下载安装即可.
2.安装cx-oracle
2.1pip安装(linux或者windows):
python -m pip install cx_Oracle --upgrade2.2 rpm包安装(linux)
2.2.1 需要先安装oracle实例客户端
wget https://yum.oracle.com/repo/OracleLinux/OL7/developer/x86_64/getPackage/oracle-instantclient18.3-basic-18.3.0.0.0-2.x86_64.rpm
yum install oracle-instantclient18.3-basic-18.3.0.0.0-2.x86_64.rpm -y2.2.2 下载并安装cx-oracle
wget https://yum.oracle.com/repo/OracleLinux/OL7/developer/x86_64/getPackage/python-cx_Oracle-7.3-1.el7.x86_64.rpm
yum install -y python-cx_Oracle-7.3-1.el7.x86_64.rpm3.测试:
创建测试表:
create table test_python(id number, name varchar2(20));
select * from test_python;编写python脚本,参考如下:
import cx_Oracle
userName="ygss"
password="ygss"
with cx_Oracle.connect(userName, password, "192.168.101.171/oggspdb",encoding="UTF-8") as connection:
cursor = connection.cursor()
cursor.execute("insert into test_python values (:1, :2)",(1,'python'))
connection.commit()然后执行该脚本即可
本次实验使用jupyter
登录数据库查询:
举报
腾讯云开发者
