python 连接Oracle db

原来只是个小丑

已于 2023-11-14 15:48:46 修改

阅读量242

点赞数

文章标签：数据库 python oracle

于 2023-11-14 15:47:31 首次发布

本文链接：https://blog.csdn.net/qq_35889665/article/details/134400833

版权

import subprocess


def execute_sql_plus(sql_plus_cmd):
    p = subprocess.Popen(sql_plus_cmd, stdout=subprocess.PIPE, stderr=subprocess.PIPE, shell=True)
    out, err = p.communicate()
    if p.returncode != 0:
        raise Exception("failed to execute sql")
    return out


out = execute_sql_plus(
    "sqlplus -S user/pwd@dbname <<EOF\nselect distinct regulation from crr2_legal_entity;\nEOF > ")

print(out.decode("utf-8"))

参考：
https://www.ycpai.cn/python/zmII787S.html