开发笔记:python使用oracle

1 #!/usr/bin/env python
2 # -*- coding: UTF-8 -*-
3 #@contact: [email&＃160;protected] @time: 2018/9/2 21:36
4 import cx_Oracle
5 cOnn=cx_Oracle.connect(‘scott/[email&＃160;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()