問題ID： 19715
問題ID： 19715
msg# 1
lily02585lee
投稿数: 11
投稿数: 11
ユーザーA：
SQL> SELECT d.department_name, e.employee_name
2 FROM departments d JOIN employees e USING (department_id)
3 FOR UPDATE OF e.employee_name NOWAIT; …
ユーザーB：
SQL> SELECT employee_id, employee_name FROM employees
2 FOR UPDATE NOWAIT; …
SQL> SELECT departmen_id, department_name FROM department
2 FOR UPDATE NOWAIT; …
ユーザーA：
SQL> UPDATE employees SET salary = 350000 WHERE employee_id = 1020;
SQL> COMMIT;
-----------------------------------------------------
SQL> SELECT departmen_id, department_name FROM department
2 FOR UPDATE NOWAIT; …
スベリンングミス department → departments
SQL> SELECT d.department_name, e.employee_name
2 FROM departments d JOIN employees e USING (department_id)
3 FOR UPDATE OF e.employee_name NOWAIT; …
ユーザーB：
SQL> SELECT employee_id, employee_name FROM employees
2 FOR UPDATE NOWAIT; …
SQL> SELECT departmen_id, department_name FROM department
2 FOR UPDATE NOWAIT; …
ユーザーA：
SQL> UPDATE employees SET salary = 350000 WHERE employee_id = 1020;
SQL> COMMIT;
-----------------------------------------------------
SQL> SELECT departmen_id, department_name FROM department
2 FOR UPDATE NOWAIT; …
スベリンングミス department → departments
投稿ツリー
-
問題ID： 19715
(lily02585lee, 2015-8-30 22:58)
-
Re: 問題ID： 19715
(staff_meg, 2015-8-31 9:40)
-
