(Solved) : Direction Use Employees Table Perform Activity Sample Output Per Number Write Pl Sql Gener Q29224089 . . . .

Direction:

Use the EMPLOYEES table to perform this activity.

In each sample output per number, write the PL/SQL that willgenerate output per number as shown below.

CREATE TABLE EMPLOYEES(EMPLOYEE_ID NUMBER(3) PRIMARY KEY,FIRSTNAME VARCHAR(10),LASTNAME VARCHAR(10)NOT NULL,JOB_ID VARCHAR(10),SALARY NUMBER(8,2),MANAGER_ID NUMBER(6),DEPARTMENT_ID NUMBER(4));INSERT INTO EMPLOYEES VALUES (100,’STEVEN’,’KING’,’AD_PRES’,24000,NULL,90);INSERT INTO EMPLOYEES VALUES (101,’NENA’,’KOCHAR’,’AD_VP’,17000,100,90);INSERT INTO EMPLOYEES VALUES (102,’LEX’,’DE HAAN’,’AD_VP’,17000,100,90);INSERT INTO EMPLOYEES VALUES (103,’ALEXANDER’,’HUNOLD’,’IT_PROG’,NULL,101,60);INSERT INTO EMPLOYEES VALUES (104,’BRUCE’,’ERNST’,’IT_PROG’,6000,102,60);INSERT INTO EMPLOYEES VALUES (107,’DIANA’,’LORENTZ’,’IT_PROG’,4200,103,60);INSERT INTO EMPLOYEES VALUES (124,’KEVIN’,’MOURGOS’,’ST_MAN’,5800,100,50);INSERT INTO EMPLOYEES VALUES (141,’TRINA’,’RAJS’,’ST_CLERK’,3500,124,50);INSERT INTO EMPLOYEES VALUES (142,’CURTIS’,’DAVIES’,’ST_CLERK’,3100,124,50);INSERT INTO EMPLOYEES VALUES (143,’RANDALL’,’MATOS’,’ST_CLERK’,2600,124,50);INSERT INTO EMPLOYEES VALUES (144,’PETER’,’VARGAS’,’ST_CLERK’,2500,124,50);INSERT INTO EMPLOYEES VALUES (149,’ELENI’,’ZLOTKEY’,’SA_MAN’,10500,100,80);INSERT INTO EMPLOYEES VALUES (174,’ELLEN’,’ABEL’,’SA_REP’,11000,149,50);INSERT INTO EMPLOYEES VALUES (176,’JONATHAN’,’TAYLOR’,’SA_REP’,8600,149,80);INSERT INTO EMPLOYEES VALUES (178,’KIMBERLEY’,’GRANT’,’SA_REP’,7000,149,NULL);INSERT INTO EMPLOYEES VALUES