HomeЛюди и блогиRelated VideosMore From: Kishan Mashru

UPDATE STATEMENT WITH JOIN IN ORACLE SQL

7 ratings | 2519 views
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);
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.