For alFor all the implemented tasks, your report or output must include a listing of all PL$/$SQL statements processed. To achieve that put the following SQL$*$Plus commands in all your scripts:

SPOOL file$-$name

SET ECHO ON

SET FEEDBACK ON

SET LINESIZE $100$

SET PAGESIZE $200$

SET SERVEROUTPUT ON

at the beginning of SQL script and

SPOOL OFF

at the end of SQL script.

PL$/$SQL Function

Implement a stored PL$/$SQL function FINDDEPENDENTS that finds the names of dependents of an employee by given employee$$s 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.

When ready append all solutions for the questions above into an SQL script file solution$3.$sql$.$ Next, process the entire script and spool the output to a spool file solution$3$Output.lst$.$

Deliverables

Submit your spooled file solution$3$Output.lst that contains your SQL script and the output from the execution of the script solution$3.$sql$.$ The report must have no errors related to the implementation of your task and it must list all PL$/$SQL and SQL statements processed.

Remember to set ECHO option of SQL$*$Plus to ON$!$l the implemented tasks, your report or output must include a listing of all PL$/$SQL statements processed. To achieve that put the following SQL$*$Plus commands in all your scripts:

SPOOL file$-$name

SET ECHO ON

SET FEEDBACK ON

SET LINESIZE $100$

SET PAGESIZE $200$

SET SERVEROUTPUT ON

at the beginning of SQL script and

SPOOL OFF

at the end of SQL script.

PL$/$SQL Function

Implement a stored PL$/$SQL function FINDDEPENDENTS that finds the names of dependents of an employee by given employee$$s 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.

When ready append all solutions for the questions above into an SQL script file solution$3.$sql$.$ Next, process the entire script and spool the output to a spool file solution$3$Output.lst$.$

Deliverables

Submit your spooled file solution$3$Output.lst that contains your SQL script and the output from the execution of the script solution$3.$sql$.$ The report must have no errors related to the implementation of your task and it must list all PL$/$SQL and SQL statements processed.

Remember to set ECHO option of SQL$*$Plus to ON$!$