Required:

Use the Employees table (copy and paste the code in SQL command line)

Based on the given table: Employees table as shown below, write the PL/SQL that applies single row function in order to get the printed output per number.

Copy and paste the PL/SQL code on the space provided after each questions.

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 (200, 'JENNIFER','WHALEN','AD_ASST',4400,101,10);

INSERT INTO EMPLOYEES VALUES (201,'MICHAEL','HARTSTEIN','MK_MAN',13000,100,20);

INSERT INTO EMPLOYEES VALUES (202,'PAT','FAY','MK_REP',6000,201,20);

INSERT INTO EMPLOYEES VALUES (205,'SHELLEY','HIGGINS','AC_MGR',12000,101,110);

INSERT INTO EMPLOYEES VALUES (206,'WILLIAM','GIETZ','AC_ACCOUNT',8300,205,110);

King,Steven Hunold,Alexander Ernst,Bruce Lorentz, Diana FIRSTNAME SALARY BONUS 24000 $$$26300 17000 $$$18600 17000 $$$18600 TEVEN ENA EX LEXANDER RUCE IANA 6000 $$$$6500 4200 $$$$4520 10500 $$$11450 8600 $$$$9360 13000 $$$14200 6000 $$$$6500 ELENI JONATHAN ICHAEL AT 3. LASTNAME SALARY RPAD (SALARY,4, '@ ERNST LORENTZ MOURGOS TAYLOR GRANT WHALEN FAY GIETZ 6000 6000 4200 4200 5800 5800 8600 8600 7000 7000 4400 4400 6000 6000 8300 8300 ET RECORD 4 LNAME kingwith a salary of24000 hunoldwith a salary of 4