Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Oracle Solaris 11 System Administration

Authors: Bill Calkins

1st Edition

0133007170, 9780133007176

More Books

Students also viewed these Databases questions