Question: Implement a stored PL / SQL function FINDDEPENDENTS that finds the names of dependents of an employee by given employee s number ( e# )

Implement a stored PL/SQL function FINDDEPENDENTS that finds the names of
dependents of an employee by given employees number(e#). The function must return
a string of characters that contains all dependents names. All names of dependents
must be separated by commas (,).
Execute the stored PL/SQL function FINDEPENDENTS. A fragment of sample printout is
given below:
00100 Albert: Bolt, Edee, Judy
00110 Alvin:
00120 Alice: Blures, Edee, Kadi
...
When ready append all solutions for the questions above into an SQL script file
solution3.sql. Next, process the entire script and spool the output to a spool file
solution3Output.lst.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!