Question: Create a metric distant conversion program.. in oracle sql Ask user three questions and collect them with & substitution values 1 st : from where

Create a metric distant conversion program.. in oracle sql

Ask user three questions and collect them with & substitution values

1st: from where (it could be cm , mt, km , mm)

2nd: to where: (it could be cm , mt, km , mm)

3rd: amount

For instance if 1stand 2ndentry same send a print message same metric conversion is not possible and stop the program

If for instance, 1stvariable value is from km then 2ndvariable is to where cm and 3rdvariable amount is 1 then result will be 1km = 1000cm

---i have create one but its not complete .

DECLARE

KM NUMBER := 4;

meter NUMBER := 0;

Cem NUMBER := 0;

BEGIN

meter := km * 1000;

Cem := meter * 100;

dbms_output.Put_line('The value of KM NUMBER KM to meters is: ' ||meter);

dbms_output.Put_line('The value of KM NUMBER KM to centimeters is: ' ||cem);

END;

---

how to complete this ?i found mine not complete/

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!