Python programming | Insert data into database table using python

[@mithunchandra8221]

Very Very Nice Explanation,Sir. Needs More.

[@edsonpadilha5397]

Parabéns @Kishan! Brasil!

[@informaticonfig333]

Excelent!

[@dhruvajyotidas1404]

Hi Kishan, thanks in ton for your help. Had one question! How would you handle Oracle sequence while you would generate primary key for each insert? Can you drop the syntax

[@dhruvajyotidas1404]

Hey I obtained the solution by using Oracle function to generate sequence numbers using the return value as insert into database.

[@fernandohood5542]

What is the syntax when specifying fields? What about %? You spend more time on error handling than the SQL portion.

[@Travellife8877]

Hi but how to handle if one column is a json field...?char field and integer field is ok..but what about json field

[@KishanMashru]

Json could be considered as a String and inserted!!!

[@bhuvanp9698]

Can we do sql copy using visual studio code to refresh complete table from production to dev environment?

[@biju2001]

Hi Kishan. import cx_Oracle give me an error. Unable to import 'cx_Oracle'pylint(import-error). I am using Visual studio code

[@ulissesavelar9360]

How can I do to get values from templates given by users and pass into WHERE from SQL?

[@charultyagi6459]

How could I insert the text file in sql using python version 2.7.2

[@kanavsharma4020]

How can we dynamically add data into tables using python and angular