Python 连接 oracle笔记

最新推荐文章于 2024-09-13 11:20:08 发布

大鹏的NLP博客

最新推荐文章于 2024-09-13 11:20:08 发布

阅读量916

点赞数

分类专栏： Python 文章标签： python oracle

本文链接：https://blog.csdn.net/philosophyatmath/article/details/41119061

版权

Python 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

Python2.7

oracle10g

cx_Oracle:cx_Oracle-5.1.2-10g.win32-py2.7.msi. Download http://sourceforge.net/projects/cx-oracle/files/

import cx_Oracle

host = 'localhost' 
port = '1521' 
dbase = 'testsid' 
login = 'scott' 
password = 'pwd' 
dsn = cx_Oracle.makedsn(host, port, dbase) 
print (dsn)
conn = cx_Oracle.connect(login, password, dsn) 

cursor = conn.cursor ()
cursor.execute ("select * from emp t")
result = cursor.fetchall ()

for row in result: 
    print (row)

cursor.close ()
conn.close ()

输出：

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=testsid)))
(7369, 'SMITH', 'CLERK', 7902, datetime.datetime(1980, 12, 17, 0, 0), 800.0, None, 20)
(7499, 'ALLEN', 'SALESMAN', 7698, datetime.datetime(1981, 2, 20, 0, 0), 1600.0, 300.0, 30)
(7521, 'WARD', 'SALESMAN', 7698, datetime.datetime(1981, 2, 22, 0, 0), 1250.0, 500.0, 30)
(7566, 'JONES', 'MANAGER', 7839, datetime.datetime(1981, 4, 2, 0, 0), 2975.0, None, 20)
(7654, 'MARTIN', 'SALESMAN', 7698, datetime.datetime(1981, 9, 28, 0, 0), 1250.0, 1400.0, 30)
(7698, 'BLAKE', 'MANAGER', 7839, datetime.datetime(1981, 5, 1, 0, 0), 2850.0, None, 30)
(7782, 'CLARK', 'MANAGER', 7839, datetime.datetime(1981, 6, 9, 0, 0), 2450.0, None, 10)
(7788, 'SCOTT', 'ANALYST', 7566, datetime.datetime(1987, 4, 19, 0, 0), 3000.0, None, 20)
(7839, 'KING', 'PRESIDENT', None, datetime.datetime(1981, 11, 17, 0, 0), 5000.0, None, 10)
(7844, 'TURNER', 'SALESMAN', 7698, datetime.datetime(1981, 9, 8, 0, 0), 1500.0, 0.0, 30)
(7876, 'ADAMS', 'CLERK', 7788, datetime.datetime(1987, 5, 23, 0, 0), 1100.0, None, 20)
(7900, 'JAMES', 'CLERK', 7698, datetime.datetime(1981, 12, 3, 0, 0), 950.0, None, 30)
(7902, 'FORD', 'ANALYST', 7566, datetime.datetime(1981, 12, 3, 0, 0), 3000.0, None, 20)
(7934, 'MILLER', 'CLERK', 7782, datetime.datetime(1982, 1, 23, 0, 0), 1300.0, None, 10)