Course Solutions Uncategorized (Solved) : Part 2 Writing Pl Sql Program Addresses Exceptions S Code Enter Pl Sql Block Query Builder Q30018272 . . . .

(Solved) : Part 2 Writing Pl Sql Program Addresses Exceptions S Code Enter Pl Sql Block Query Builder Q30018272 . . . .

 

Part 2: Writing a PL/SQL program which addresses exceptions

Here’s the code.

DECLARE CURSOR CUR EMPLOYEE DETAILS AS e.employee id select e.first name e.last name e.full name, e.job id, e.salary from where employees e e.salary 50000; RV ENPLOYEE DETAILS CUR EMPLOYEE DETAILS%ROWTYPE; BEGIN OPEN CUR EMPLOYEE DETAILS FETCH CUR MPLOYEE DETAILS LOOP DBMS OUTPUT. PUT LINE (Employee ID : rv employee_details.employee id)i ? 11 Complete the remaining display of employee s data based on the join statement. EXIT WHEN RV EMPLOYEE DETAILS%NOTFOUND; END LOOP EXCEPTION WHEN NO DATA FOUND THEN DBMS OUTPUT. PUT LINE No data found) END;

Enter

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post