(Solved) : Pl Sql Create Anonymous Blocks Question Must Use Cursor Loop Else 1 Create Anonymous Block Q34968667 . . . .

PL/SQL – Create Anonymous Blocks

For each question, you must use a cursor, a while loop and anif-then-else.  

1.  Create an anonymous block that will count thenumber of students whose gr_t1 grade is higher than the average ongr_t1 and display that number.

2.  Create an anonymous block that will give displaythe name of student if the average of his gr_t1 and gr_t2 isgreater than the average of his gr_hw and gr_pr.

3.  Create an anonymous block that will give displaythe name of student of the female students.

Tables:

student (std_code , std_fname, std_lname, std_gend, maj_code,std_dob)

grade (std_code, std_fname, std_lname, gr_t1, gr_t2, gr_hw,gr_pr, gr_avg, gr_lg)

Expert Answer

An answer will