Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 PLSQL statements processed. To achieve that put the following SQLPlus commands in all your scripts:
SPOOL filename
SET ECHO ON
SET FEEDBACK ON
SET LINESIZE
SET PAGESIZE
SET SERVEROUTPUT ON
at the beginning of SQL script and
SPOOL OFF
at the end of SQL script. Task marks
PLSQL Function
Implement a stored PLSQL function FINDDEPENDENTS that finds the names of dependents of an employee by given employees numbere# 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 PLSQL function FINDEPENDENTS. A fragment of sample printout is given below:
Albert: Bolt, Edee, Judy
Alvin:
Alice: Blures, Edee, Kadi
When ready append all solutions for the questions above into an SQL script file solutionsql Next, process the entire script and spool the output to a spool file solutionOutput.lst
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started