taracoder

it is very popular website your help anytime please search this site asked any question and tag.

Thursday, December 3, 2020

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