Connect to Oracle database from python

import pandas as pd

import cx_Oracle

## db parameters

user_name = 'myusernamehere'

password = 'mypasswordhere'

query = 'select * from mydbdb.table_name where rownum < 20 and creation_date > sysdate - 2'

## connect to the DW and query the data

dsn = cx_Oracle.makedsn('Thehostname', portnumber, 'Thedbname')

con = cx_Oracle.connect(user_name, password, dsn)

curs = con.cursor()

curs.execute(query)

## Convert the cx_Oracle object to pandas dataframe

headers = [ x[0] for x in curs.description]

data = curs.fetchall()

df = pd.DataFrame( data, columns=headers)

## display the dataframe

df

## The type conversion is also pretty accurate

df.dtypes