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

Question

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.

i put already the structure and can somebody help me...thank you!

Direction: 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. Write your answer in a short bond paper. Copy and paste the PL/SQL code on the space provided after each questions. EMPLOYEE ID FIRSTNAME LASTNAME JOB ID SALARY MANAGER ID DEPARTMENT ID AD PRES 90 100 STEVEN KING 101 NENA 102 LEX 103 ALEXANDER HUMOLD ItPROG 104 BRUCE ERNST IT PROG 107 DIANA LORENT IT PROG 124 REV?H HOURGOS ST MAN 141 TR?RA RAJ3 42 CURIIS DAVIES SI CLER 143 RANDALL HATOS ST CLERR 44 PETER VARGAS ST CUERR 24000 17000 17000 100 100 101 102 103 100 ROCHARAD VE DE HAAN AD VP 90 60 60 60 50 50 50 50 50 - 6000 4200 5800 3500 3100 2600 2500 10500 11000 9 600 1006 1400 9000 T CLERR 124 124 124 160 14 ELLENABELSh REP 176 JONATHAN TAYLOR B RE 90 201 HICHAEL 03 PA HART?18 HE HAS MHREF 106 a0i 2000 108 King,Steven lunold, Alexanden rnst, Bruce Lorentz Diana

Explanation / Answer

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));
You have made changes to the database.

INSERT INTO EMPLOYEES VALUES (100,'STEVEN','KING','AD_PRES',24000,NULL,90);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (101,'NENA','KOCHAR','AD_VP',17000,100,90);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (102,'LEX','DE HAAN','AD_VP',17000,100,90);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (103,'ALEXANDER','HUNOLD','IT_PROG',NULL,101,60);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (104,'BRUCE','ERNST','IT_PROG',6000,102,60);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (107,'DIANA','LORENTZ','IT_PROG',4200,103,60);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (124,'KEVIN','MOURGOS','ST_MAN',5800,100,50);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (141,'TRINA','RAJS','ST_CLERK',3500,124,50);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (142,'CURTIS','DAVIES','ST_CLERK',3100,124,50);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (143,'RANDALL','MATOS','ST_CLERK',2600,124,50);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (144,'PETER','VARGAS','ST_CLERK',2500,124,50);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (149,'ELENI','ZLOTKEY','SA_MAN',10500,100,80);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (174,'ELLEN','ABEL','SA_REP',11000,149,50);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (176,'JONATHAN','TAYLOR','SA_REP',8600,149,80);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (178,'KIMBERLEY','GRANT','SA_REP',7000,149,NULL);

You have made changes to the database. Rows affected: 1

INSERT INTO EMPLOYEES VALUES (200, 'JENNIFER','WHALEN','AD_ASST',4400,101,10);

You have made changes to the database. Rows affected: 1

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

You have made changes to the database. Rows affected: 1

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

You have made changes to the database. Rows affected: 1

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

You have made changes to the database. Rows affected: 1

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

You have made changes to the database. Rows affected: 1

SELECT LASTNAME, FIRSTNAME FROM EMPLOYEES WHERE JOB_ID = 'AD_PRES' OR JOB_ID = 'IT_PROG';

Number of Records: 4

LASTNAME FIRSTNAME

KING STEVEN

HUNOLD ALEXANDER

ERNST BRUCE

LORENTZ DIANA

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.