Course Solutions Uncategorized (Solved) : Consider Following Employees Table Employees Dno 2001 Rami Ajman 2002 Sahardubai 3000 4000 Q30120886 . . . .

(Solved) : Consider Following Employees Table Employees Dno 2001 Rami Ajman 2002 Sahardubai 3000 4000 Q30120886 . . . .

 

Distributed and object Database
Consider the following Employees Table Employees DNO 2001 Rami Ajman 2002 SaharDubai 3000 4000 3500 6000 9000 2000 6500 2004 Manal Sharjah2 2007 ALI AbuDhabi 2005 Ahmed Sharjah 2008 Sami AbuDhabi 3 2006 Salim Sharjah1 1. Write a PL/SQL statements that create a stored procedure named that updates the basicSalary for Employees of a certain department. The procedure receives two parameters, department number and percentage increase. The procedure uses the values of these parameters to update the basic salaries of the employee of that department and display the number of updated rows. Create a PL/SQL block that read two values related to DNO and Percentage increase and call the procedure raisSalary to perform the update. Hint use cursor conceptConsider

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