Hi guys, Welcome to the Advanced Video Search Engine, and you are watching UPDATE STATEMENT WITH JOIN IN ORACLE SQL. That video is uploaded by Kishan Mashru at 2016-05-24T10:50:38-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [Ct31VsbGdoE]
| Name | UPDATE STATEMENT WITH JOIN IN ORACLE SQL |
| Video Uploader | Video From Kishan Mashru |
| Upload Date | This Video Uploaded At 24-05-2016 17:50:38 |
| Video Discription | This video demonstrates how user can update data of a particular table(t1), based on the join condition with other table(t2). So it would be a easy way to ditch the for-loop, and check for the condition every time. What was to be achieved from the for-loop can be achieved with a single simple update statement. A simple trick to update data in table based on some conditional data in some another table, would help you to increase the performance of your code massively. For ex : UPDATE TABLE1 t1 SET COL1 = (SELECT COL FROM TABLE2 t2 where t1.col = t2.col); Ct31VsbGdoE |
| Category | People & Blogs |
| Tags | update statement with join | update statement in oracle with join | oracle update from another table | update statement in oracle by joining 2 tables | update statement in oracle using inner join | update statement in oracle | oracle statement in sql | join | inner join | join with update | oracle | sql | oracle sql | oracle pl/sql | pl sql tutorials | tutorials | sql expert tutorial | sql tutorials | sql developer | kishan mashru | sql and pl/sql |
