python+sqlplus，,importosfr

python+sqlplus，,importosfr

importosfromsubprocessimportPopen,PIPEsqlplus=Popen(["sqlplus","-S","andy/root"],stdout=PIPE,stdin=PIPE)sqlplus.stdin.write("selectsysdatefromdual;"+os.linesep)sqlplus.stdin.write("insertintot_pythonvalues(1,‘chenlong‘);"+os.linesep)sqlplus.stdin.write("insertintot_pythonvalues(2,‘xiao‘);"+os.linesep)sqlplus.stdin.write("selectcount(*)fromt_python;"+os.linesep)sqlplus0.stdin.write("selectcount(*)fromemp;"+os.linesep)out,err=sqlplus.communicate()printoutsqlplus0=Popen(["sqlplus","-S","scott/root"],stdout=PIPE,stdin=PIPE)out0,err0=sqlplus0.communicate()printout0

本文出自 “天空海阔” 博客，请务必保留此出处http://ether007.blog.51cto.com/8912105/1539652

python+sqlplus,布布扣,bubuko.com

python+sqlplus