Question: For all the implemented tasks, your report or output must include a listing of all PL / SQL statements processed. To achieve that put the

For 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. Task 3(2.5 marks)
PL/SQL Function
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!