Description

Create table for following schema and insert suitable data into it:
1. N_RollCall(RollNo,Name, Branch, Year, Attendance_Percentage, Event)
2. O_RollCall(RollNo,Name, Branch, Year, Attendance_Percentage, Event)
Write a PL/SQL block of code to perform below operations:-
1. Write a PL/SQL block using cursor to count total number of rows updated after increasing attendance of students participated in cultural events by 20% . (IMPLICIT Cursor)
2. Write a PL/SQL block to display student details from computer department. (EXPLICIT Cursor)
3. Write a PL/SQL block to show student detail having attendance greater than 60% (Cursor FOR)
4. Write a PL/SQL block of code using parameterized Cursor, which will merge the data available in the newly created table N_RollCall with the data available in the table O_RollCall. If the data in the first table already exist in the second table then that data should be skipped (PARAMETERIZED Cursor)