To link any database with our Python program, we needed some kind of connector, which is nothing other than module cx_Oracle .
To install cx_Oracle:
pip install cx_Oracle
With this command you can install the cx_Oracle package , but first you need to install the Oracle database on your PC.
How to use this module to connect
con = cx_Oracle.connect ('username / password @ localhost')
cursor = cx_Oracle.cursor ()
cursor.execute (sqlquery) - - - - & gt; to execute single query.
cursor.execute (sqlqueries) - - - - & gt; to execute a group of multiple sqlquery seperated by “;”
cursor.close () con.close ()
Table Created successful
Insert into table: strong>
value inserted successful
Vincent Bumgarner has been designing software for nearly 20 years, working in many languages on nearly as many platforms. He started using Splunk in 2007 and has enjoyed watching the product evolve ov...
Why this Book? Hadoop has been the base for most of the emerging technologies in today’s big data world. It changed the face of distributed processing by using commodity hardware for large data set...
As the title promises, this book will introduce you to one of the world’s most popular programming languages: Python. It’s aimed at beginning programmers as well as more experienced programmers wh...
Pandas for Everyone: Python Data Analysis (Addison-Wesley Data & Analytics Series), 1st Edition. Pandas for Everyone brings together the practical knowledge and insights you need to solve real-worl...