Getting Started:#!/usr/bin/python
import cx_Oracle
connstr='scott/tiger'
conn = cx_Oracle.connect(connstr)
curs = conn.cursor()
curs.arraysize=50
curs.execute('select 2+2 "aaa" ,3*3 from dual')
print curs.description
print curs.fetchone()
conn.close()
Resources:
-
Python Programming Language - Official Website
-
cx_Oracle module for accessing Oracle Database from Python (DB API 2.0 conformant, updated for 11g)
-
Pydev, a superb IDE for Python built on top of Eclipse
-
Mod_python, Apache/Python Integration, introducing Python Server Pages technology
-
Python Package Index - official repository for 3rd party modules
-
comp.lang.python - active, helpful community of Python experts
Python-based:
-
Jython - Python implemented in pure Java
-
IronPython - Microsoft's implementation of Python in C# with all benefits of the .NET CLR