You are required to write programming code by creating a procedure, function, or trigger inPL/SQL(It is a Database programming language) and then show the evidence by calling the procedure, function, or trigger inPL/SQLanonymous block.
Also, for each question, the followings must be included in the word document
1. ThePL/SQLcode as a text
2. The screenshot ofPL/SQLin oracle UI
3. The result/output of thePL/SQLin oracle UI
4. Each screenshot should contain your id or name (as logged in user)