Question

Q2 Given the following emp_tbl: (CLOI) 6 Marks first name Ahmad last name Salah Ali Hassan salary 10,000 9,000 ,000 empID Amira 200 300 Saeed (i) Write a P/SQL procedure that: a. Declares two variables of type first_name and salary columns, respectively. b. Declares a cursor that includes the first_name and salary columns. c. Fetches the values in the cursor into the declared variables. d. Prints these values in the following form: First name Salary Ahmad 10,000 Amira 9,000 7,000 Saeed Ans: (ii) Write a function that receive empiD argument and returns the salary. Ans:

Answer 1

CRENTE Procedre emp salo Cursor c s Select fir st name Salary fiom emP.tblゾ BEGIN open с. LINEC'Fiyst nane'l DeMS-OOTPUT. puLL S alau Loop Fetch c int fiast name, Salo EXİt u hen cy, not found close E ND

Cseate function emp( eid RETUR numbex ts umber (3)) Sal umbes CLo) BEGIN Salect salay into sol om emp tb RETURN Sa END

I f there are any doubts, comment down here. Weareright here to help you. H appyLearning..!! Please HITaLIKEif youlike the answer, it really Boosts us..! Please HITaLIKEif youlike the answer, it really Boosts us..!!