PYTHON: Connecting to DB

import cx_Oracle as ora

dbCon=ora.connect(UserName,UserPwd,dbSID)
dbCursor=dbCon.cursor()
getDetails=”’select * from Tablename where columnName=:cloumnName”’
dbCursor.execute(getDetails,cloumnName=colName)
TotalcolumnsData=cursor.fetchall()
noOfTotalcolumnsData=len(TotalcolumnsData)
for i in range(noOfTotalcolumnsData):
logic

Leave a comment