发布时间:2019-09-18 07:24:51编辑:auto阅读(1875)
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
上一篇: Python -- str 类
下一篇: python版wc
51063
50454
41055
37920
32389
29281
28159
23000
22962
21293
1308°
2004°
1666°
1593°
1884°
1678°
2343°
3943°
3855°
2754°