Python 官方文档:入门教程 => 点击学习
import os from subprocess import Popen,PIPE sqlplus = Popen(["sqlplus", "-S", "andy/root"], stdout=PIPE, stdin=PIPE) s
import os
from subprocess import Popen,PIPE
sqlplus = Popen(["sqlplus", "-S", "andy/root"], stdout=PIPE, stdin=PIPE)
sqlplus.stdin.write("select sysdate from dual;"+os.linesep)
sqlplus.stdin.write("insert into t_python values(1,'chenlong');"+os.linesep)
sqlplus.stdin.write("insert into t_Python values(2,'xiao');"+os.linesep)
sqlplus.stdin.write("select count(*) from t_python;"+os.linesep)
sqlplus0.stdin.write("select count(*) from emp;"+os.linesep)
out, err = sqlplus.communicate()
print out
sqlplus0 = Popen(["sqlplus", "-S", "scott/root"], stdout=PIPE, stdin=PIPE)
out0, err0 = sqlplus0.communicate()
print out0
--结束END--
本文标题: python+sqlplus
本文链接: https://www.lsjlt.com/news/190702.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0