Lock student ID 00101 for update of major to 600. Update the row and commit it.

Question

Use case study databases for the following queries.

Answer 1

```
SQL> SELECT *
2 FROM STUDENT
3 WHERE STUDENTID = '00101'
4 FOR UPDATE OF MAJORID
5 NOWAIT;

STUDE LAST FIRST STREET CITY
----- --------------- --------------- ------------------------- ---------------
ST ZIP STAR BIRTHDATE FACULTYID MAJORID PHONE
-- ----- ---- --------- ---------- ---------- ----------
00101 TYLER MICKEY 12 MORRIS AVENUE BRONX
NY 10468 SP03 18-MAR-84 555 500 7185552222


SQL> UPDATE STUDENT
2 SET MAJORID=600
3 WHERE STUDENTID='00101';

1 ROW UPDATED.

SQL> COMMIT
2 /

COMMIT COMPLETE.
```