自行下载安装即可.
python -m pip install cx_Oracle --upgrade
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 -y
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.rpm
创建测试表:
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
登录数据库查询:
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。