The indicated errors and pauses will not actually happen in the Oracle Academy's online Application Express. We are going to set up two sessions into the same schema. Open a second session in a new browser window and connect to your schema. You now have a lock on row that will last indefinitely. Execute your code. What happens? Re-execute the block. What happens this time? Then switch back to your second session.
What happened? Popular Posts. Play My Game. Chicken Nuggets by barragames. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
Collectives on Stack Overflow. Learn more. Asked 9 years, 5 months ago. Active 2 months ago. Viewed k times. Improve this question. Your code is not working fine because it's not doing what you're talking about. I'm surprised why it doesn't throw exceptions. The IF condition to evaluate if it's the case to insert the records is wrong because it would insert only new duplicates. Ben's proposed solution would work fine if studId is unique in both studLoad and student tables.
Add a comment. Active Oldest Votes. However, as I say this will not be as efficient as merge. Improve this answer. Ben Ben AlessandroRossi, you are, of course, correct. I've updated it.
Aleksandar Aleksandar 21 2 2 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.
Sign up using Email and Password. Post as a guest Name.
0コメント