发布时间:2019-09-18 07:24:51编辑:auto阅读(1879)
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
51158
50567
41185
38015
32481
29385
28245
23100
23065
21386
1438°
2148°
1782°
1704°
2008°
1779°
2455°
4132°
4002°
2856°