Description

Create table for following schema and insert suitable data into it:
1. Borrower(Rollin, Name, DateofIssue, NameofBook, Status)
Write a PL/SQL block of code to perform below operations:-
1. Accept roll_no & name of book from user. (at present assign values to variables in program only)
3. After submitting the book, change status (column in Borrower table) from I to R. (I-issue and R-return)
4. If condition of fine is true, then details will be stored into fine table.
5. Write exception handling block as per requirement. (User defines and System defined exception)