HOW TO FIX THIS CODE IN ORACLE SQL ? CREATE OR REPLACE PROCEDURE CONVERT_VAL(V1 VARCHAR,V2 VARCHAR,AMT NUMBER) IS val VARCHAR2(100); val1 VARCHAR2(2); val2 varchar2(2); amount number; DECLARE meter NUMBER := 0; Cem NUMBER := 0; BEGIN val1:=v1; val2:=v2; amount:=amt; Select case when val1!=val2 then case when lower(val1)='km' 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); when lower(val1)='m' dbms_output.Put_line('The value of M NUMBER M to KM is: ' ||KM); dbms_output.Put_line('The value of M NUMBER M to centimeters is: ' ||cem); when lower(val1)='Cm' dbms_output.Put_line('The value of M NUMBER CM to KM is: ' ||KM); dbms_output.Put_line('The value of M NUMBER CM to M is: ' ||M); else 'same metric conversion is not possible OR YOUR INPUT IS INCORRECT ' end as val into val from dual; dbms_output.Put_line(val); END; / BEGIN CONVERT_VAL; END; ------I ENTER METER ,KM OR CM ,IT WILL convert to the corresponding other unit。 the code is not working .
HOW TO FIX THIS CODE IN ORACLE SQL ?
CREATE OR REPLACE PROCEDURE CONVERT_VAL(V1 VARCHAR,V2 VARCHAR,AMT NUMBER) IS
val VARCHAR2(100);
val1 VARCHAR2(2);
val2 varchar2(2);
amount number;
DECLARE
meter NUMBER := 0;
Cem NUMBER := 0;
BEGIN
val1:=v1;
val2:=v2;
amount:=amt;
Select case when val1!=val2 then
case
when lower(val1)='km'
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);
when lower(val1)='m'
dbms_output.Put_line('The value of M NUMBER M to KM is: ' ||KM);
dbms_output.Put_line('The value of M NUMBER M to centimeters is: ' ||cem);
when lower(val1)='Cm'
dbms_output.Put_line('The value of M NUMBER CM to KM is: ' ||KM);
dbms_output.Put_line('The value of M NUMBER CM to M is: ' ||M);
else
'same metric conversion is not possible OR YOUR INPUT IS INCORRECT '
end
as val into val
from dual;
dbms_output.Put_line(val);
END;
/
BEGIN
CONVERT_VAL;
END;
------I ENTER METER ,KM OR CM ,IT WILL convert to the corresponding other unit。
the code is not working .
Step by step
Solved in 2 steps
