发布时间:2019-09-18 07:24:51编辑:auto阅读(1839)
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
50495
49799
40396
37417
31833
28696
27628
22412
22411
20726
481°
1100°
900°
835°
1080°
957°
1569°
2939°
2618°
2013°