username = "your_user_name"
userpwd = "your_pwd"
host = "127.0.0.1"
port = 1521
dbname =  "your_db"

dsn=cx_Oracle.makedsn(host, port, dbname)
connection=cx_Oracle.connect(username, userpwd, dsn)
cursor = connection.cursor()
sql = "select * from tablename "

cursor.execute(sql)

result =  cursor.fetchall()
count = cursor.rowcount
print "====================="
print "Total:", count
print "====================="
for row in result:
        print row
        print "======================="


cursor.close()
connection.close()