DBMS Lab Expriment Assignment-10 full solution

 

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).