Oracle Magazine, July/August 2018
Database Developer OPEN SOURCE ORACLE MAGAZINE JULY AUGUST 2018 101 Commits the transaction DEEPER DIVE Now delete all the birds When youre done the results should be Original Data 6 Buster 1 dog 2 Dragon 2 bird 4 Red 2 bird 5 Red 3 horse 3 Sneaky 5 snake 7 Fido 7 cat New Data 6 Buster 1 dog 5 Red 3 horse 3 Sneaky 5 snake 7 Fido 7 cat What does the successful code look like Like this cur con cursor statement delete from cx_ pets where type type cur execute statement type bird con commit Reset the data Now is a good time to run reset_ data py BOILERPLATE CHANGE Now change the boilerplate get_ all_ rows statements in delete py to get people and pet data Replace the last three code lines of delete py with
You must have JavaScript enabled to view digital editions.