Oracle Magazine, July/August 2018
Database Developer OPEN SOURCE ORACLE MAGAZINE JULY AUGUST 2018 98 3 Sneaky 5 snake 4 Red 2 bird 5 Red 3 horse 6 Buster 1 dog 7 Fido 7 cat cur bindarraysize 2 cur setinputsizes int 20 int 100 cur executemany insert into cx_ pets id name owner type values 1 2 3 4 rows con commit cur close The delete template To run the delete examples in this article create a new file called delete py with the following code import cx_ Oracle import os connectString os getenv db_ connect con cx_ Oracle connect connectString def get_ all_ rows label data_ type people Query all rows cur con cursor if data_ type pets
You must have JavaScript enabled to view digital editions.