Answered step by step
Verified Expert Solution
Link Copied!

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 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

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

Database Machine Performance Modeling Methodologies And Evaluation Strategies Lncs 257

Authors: Francesca Cesarini ,Silvio Salza

1st Edition

3540179429, 978-3540179429

More Books

Students also viewed these Databases questions