Table Name: PARTS

CREATE TABLE PARTS(

PARTNUM CHAR(4) PRIMARY KEY,

DESCRIPTION VARCHAR(20),

ONHAND NUMBER(6),

CLASS CHAR(5),

WAREHOUSE NUMBER(6),

PRICE NUMBER(6));

INSERT INTO PARTS VALUES('AT94', 'IRON',50,'HW',3,2495);

INSERT INTO PARTS VALUES('BVO6','HOME GYM' ,45,'SG',2,79495);

INSERT INTO PARTS VALUES('CD52','MICROWAVE OVEN',32,'AP',1,165);

INSERT INTO PARTS VALUES('DL71','CORDLESS DRILL',21,'HW',3,12995);

INSERT INTO PARTS VALUES('DR93','GAS RANGE',21,'AP',2,495);

INSERT INTO PARTS VALUES('DW11','WASHER',12,'AP',3,399);

INSERT INTO PARTS VALUES('FD21','STAND MIXER',22,'HW',3,159);

INSERT INTO PARTS VALUES('KL62','DRYER',12,'AP',1,349);

INSERT INTO PARTS VALUES('KT03','DISHWASHER',8,'AP',3,595);

INSERT INTO PARTS VALUES('KV29','TREADMILL',9,'SG',2,1390);

Based on the given table: PARTS as shown below, write the PL/SQL in order to get the printed output per number. Write your answer in a short bond paper.

Do not used IN condition.

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

Table Name: PARTS PARTNUM DESCRIPTION AT94 BVO6 CD52 DL71 DR93 DW11 FD21 KL62 KT03 KV29 ONHAND CLASS WAREHOUSE PRICE 50 45 IRON HOME GYM MICROWAVE OVEN | 32 CORDLESS DRILL21 GAS RANGE WASHER STAND MIXEFR DRYER DISHWASHER TREADMILL HW 2495 79495 165 12995 495 399 159 349 595 1390 SG HW 21 AP HW AP AP SG 12 12