iframe-proxy | Sunbelt Computer Software

34 lines (26 loc) · 678 Bytes

import cx_Oracle
	DB = cx_Oracle.connect('asriva01/Fiserv#123@orcl')
	print(DB.version)
except cx_Oracle.DatabaseError as e:
	error = e.args
	print ( "Oracle-Error-Code : " + error.code, sys.stderr)
	print ( "Oracle-Error-Message:" + error.message, sys.stderr)
	cur =  DB.cursor()
	#cur.execute("insert into Employees values ('101','Ankit',27,'Engineer')")
	#DB.commit()
	cur.execute('select * from Employees' )
	for result in cur:
		while (count < len(cur.description)):
			print( cur.description[count][0], end="  ")
			count += 1
		print (result)
	cur.close()
  # Close connection. 
  DB.close()

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

database.py

Latest commit

History

database.py

File metadata and controls