Consider the following Employees Table Employees DNO 2001RamiAjman 2002Sahar Dub

Question

Consider the following Employees Table Employees DNO 2001RamiAjman 2002Sahar Dubai 2003 AdamAjman 2004 Manal Sharjah 2007 2005 Ahmed Sharjah 5000 3000 4000 3500 6000 9000 2000 6500 2 AbuDhabi 1 2008 Sam AbuDhabi3 2006 Salim Sharjah 2. Write a PL/SQL statements that create a stored function named basicSalarySum. The function receives one parameter, ecity. The function calculates and returns the sum of the basic salaries of all employees in that city Create a PL/SQL block that read an Ecity from the keyboard. The program then uses that function to find and display the sum of the basic salaries of that city.

Explanation / Answer

2] Calling the function

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.