作者:白白加黑黑99_889 | 来源:互联网 | 2023-10-11 09:47
篇首语:本文由编程笔记#小编为大家整理,主要介绍了python使用oracle相关的知识,希望对你有一定的参考价值。
1 #!/usr/bin/env python
2 # -*- coding: UTF-8 -*-
3 #@contact: [email protected] @time: 2018/9/2 21:36
4 import cx_Oracle
5 cOnn=cx_Oracle.connect(‘scott/[email protected]/orcl‘)
6 c=conn.cursor()
7 sql = "select * from emp"
8 c.execute(sql)
9 for x in c.fetchall():
10 for value in x:
11 print value
12 c.close()
13 conn.close()