SQl Programming: Deadlocks & Transactions

Code the SQL using Oracle Developer IDE:

1.Create 2 tables

2,Insert data into the 2 tables

3,Generate a deadlock using update statements

4,Show a picture of the generated deadlock

5. Use transaction blocks to solve the deadlock

6. Show a picture of the deadlock not occuring after running the same update statements that generated the deadlock in the first place