python oracle db connection example

# importing module 
import cx_Oracle 


# Create a table in Oracle database 
try: 

	con = cx_Oracle.connect('user/pass@ip') 
	
	# Now execute the sqlquery 
	cursor = con.cursor() 
	
	# Creating a table srollno heading which is number 
	cursor.execute("create table student(srollno number, \ 
					name varchar2(10), efees number(10, 2)") 
					
	print("Table Created successful") 
	
except cx_Oracle.DatabaseError as e: 
	print("There is a problem with Oracle", e) 

# by writing finally if any error occurs 
# then also we can close the all database operation 
finally: 
	if cursor: 
		cursor.close() 
	if con: 
		con.close()