Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Performance Anti-Patterns: Non-query DML inside loops. That video is uploaded by Practically Perfect PL/SQL with Steven Feuerstein at 2015-03-16T14:34:44-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [lb4xu8qVuII]
| Name | Performance Anti-Patterns: Non-query DML inside loops |
| Video Uploader | Video From Practically Perfect PL/SQL with Steven Feuerstein |
| Upload Date | This Video Uploaded At 16-03-2015 21:34:44 |
| Video Discription | Lots of code follows patterns. Some of the patterns are good ones, some them are bad - and these we call "anti-patterns." In this video, Steven identifies a common and, for many, surprising anti-pattern - and then shows how to turn it into a design pattern worthy of use. The anti-pattern is the execution on non-query DML (inserts, updates, deletes) inside a loop. The refactored positive design is based on bulk processing in PL/SQL. Along the way, Steven shows how this involves moving from row-by-row to phased processing. ================================================== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement. lb4xu8qVuII |
| Category | People & Blogs |
| Tags | Program Optimization (Project Role) | Programming Language (Software Genre) | PL/SQL (Programming Language) | Oracle Database (Software) | Data Manipulation Language | Anti-pattern |
