1. Retrieve and print the data of an employee having name=’Rishi' using Record.
2. Retrieve and print the data of all the employees using Explicit Cursors.
3. Write a PL/SQL code block to
display the names and GPA of students from student table using an explicit
cursor.
4. Write a
PL/SQL code block that displays the names, GPA of students along with the
grades of students after calculation from student table using an explicit
cursor.
Add a column grade to the student table; update the
grades of students to the table after calculation. (The criteria of grade can
be considered as grade = A if gpa>3.7; and grade = B, otherwise).