Question

Oracle SQL

Many of the pages in Brewbean’s needs to display the product type as coffee or equipment. Type value for these product categories is a ‘C’ or ‘E’. Create a procedure that accepts the type C or E and returns the full description as ‘Coffee’ or ‘Equipment’. Use only 1 parameter in the procedure for this task.

Answer 1

//User input program:

//use oracle11g express software for execution

DECLARE
product char; //one parameter
BEGIN
DBMS_OUTPUT.PUT_LINE('Enter product type C or E');
product=:&product;
if(product ='C') then
DBMS_OUTPUT.PUT_LINE('Coffee');
elsif(product ='E') then
DBMS_OUTPUT.PUT_LINE('Equipment');
else
DBMS_OUTPUT.PUT_LINE('Enter valid key C or E only');
end if;
END;
/

------------------------------------------------------------------------------------------------------------------------------------------------------------

//Default values program:

DECLARE
product char:='C';
BEGIN
if(product ='C') then
DBMS_OUTPUT.PUT_LINE('Coffee');
elsif(product ='E') then
DBMS_OUTPUT.PUT_LINE('Equipment');
else
DBMS_OUTPUT.PUT_LINE('Enter valid key C or E only');
end if;
END;
/