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

UPDATE STATEMENT WITH JOIN IN ORACLE SQL

9 ratings | 4334 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 (1)
srikanth chowdary (1 month ago)
nic video but so much disturbance are their while watching

Would you like to comment?

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