python3连接Oracle

绝地灬酷狼 2022-11-05 00:54 213阅读 0赞

## 一、环境准备 ##

Oracle官网：[https://www.oracle.com/index.html][https_www.oracle.com_index.html]

百度经验：[https://jingyan.baidu.com/article/75ab0bcb9776ecd6864db2c9.html][https_jingyan.baidu.com_article_75ab0bcb9776ecd6864db2c9.html]

Oracle+Python：[https://developer.oracle.com/cn/dsl/mastering-oracle-python.html][https_developer.oracle.com_cn_dsl_mastering-oracle-python.html]

cx\_Oracle：[https://cx-oracle.readthedocs.io/en/latest/user\_guide/installation.html][https_cx-oracle.readthedocs.io_en_latest_user_guide_installation.html]

安装 cx-Oracle 驱动

官网下载：[https://pypi.org/project/cx-Oracle/\#files][https_pypi.org_project_cx-Oracle_files]

pip install cx-Oracle

## 二、实现代码 ##

import cx_Oracle
    
    conn = cx_Oracle.connect('xl/123456@127.0.0.1:1521/orcl')
    print(conn.version)
    cursor = conn.cursor()
    for i in cursor.execute("SELECT * FROM v$version"):
        print(i)
    sql = 'SELECT * FROM "t_user"'
    cursor.execute(sql)
    # row = cursor.fetchone()
    row = cursor.fetchall()
    for i in row:
        print(i)
    
    cursor.close()
    conn.close()

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70][]

[https_www.oracle.com_index.html]: https://www.oracle.com/index.html
[https_jingyan.baidu.com_article_75ab0bcb9776ecd6864db2c9.html]: https://jingyan.baidu.com/article/75ab0bcb9776ecd6864db2c9.html
[https_developer.oracle.com_cn_dsl_mastering-oracle-python.html]: https://developer.oracle.com/cn/dsl/mastering-oracle-python.html
[https_cx-oracle.readthedocs.io_en_latest_user_guide_installation.html]: https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html
[https_pypi.org_project_cx-Oracle_files]: https://pypi.org/project/cx-Oracle/#files
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70]: /images/20221023/15666bef2ddf4e11bc7a5e478dd716ff.png