先来看一个简单的利用python调用sqlplus来输出结果的例子:
import os
import sys
from subprocess import Popen, PIPE
sql =
set linesize 400
col owner for a10
col object_name for a30
select owner, object_name
from dba_objects
where rownum<=10;
proc = Popen([sqlplus, -S, /, as, sysdba], stdout=PIPE, stdin=