Question
Required: Copy and paste the PL/SQL code on the space provided after each questions. Table Name: PARTS CREATE TABLE PARTS( PARTNUM CHAR(4) PRIMARY KEY, DESCRIPTION
Required: Copy and paste the PL/SQL code on the space provided after each questions.
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);
PARTNUM | DESCRIPTION | ONHAND | CLASS | WAREHOUSE | PRICE |
AT94 | IRON | 50 | HW | 3 | 2495 |
BVO6 | HOME GYM | 45 | SG | 2 | 79495 |
CD52 | MICROWAVE OVEN | 32 | AP | 1 | 165 |
DL71 | CORDLESS DRILL | 21 | HW | 3 | 12995 |
DR93 | GAS RANGE | 21 | AP | 2 | 495 |
DW11 | WASHER | 12 | AP | 3 | 399 |
FD21 | STAND MIXER | 22 | HW | 3 | 159 |
KL62 | DRYER | 12 | AP | 1 | 349 |
KT03 | DISHWASHER | 8 | AP | 3 | 595 |
KV29 | TREADMILL | 9 | SG | 2 | 1390 |
PARTS structure
COLUMN NAME | DATA TYPE/SIZE | KEY | NULL |
PARTNUM | CHAR 4 | PRIMARY | NOT NULL |
DESCRIPTION | VARCHAR 20 |
| NOT NULL |
ONHAND | NUMBER 6 |
|
|
CLASS | CHAR 5 |
|
|
WAREHOUSE | NUMBER 6 |
|
|
PRICE | NUMBER 6 |
|
|
1. Create a report by listing the DESCRIPTION and Price (Note that in column PRICE add ADDITIONAL 10000). Get only the prices with no digit that is equal to 5. Note that you have to concatenate the said column and rename the merge column as New Price Lists. Sort the data in DESC order by Price.
2. Write the different select clause following the order of precedence.
3. What is the default order of sorting data in oracle? Write one example.
4. When is LIKE condition properly used?
5. When is IN condition properly used?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started