Q. Write a PL/SQL function to accept three parameters,
I) The sides of a triangle that should be user's choice.
II) The function should return a Boolean value, 'true' if the triangle is valid, else 'false' .
III) Check if the dimensions entered by the user can form a valid triangle. (A triangle is valid if the length of each side is less than the sum of the lengths of the other two sides.)
Answer:
Exception Code:
The following code will check if a triangle is valid or not.
Calling Code:
Output:
I) The sides of a triangle that should be user's choice.
II) The function should return a Boolean value, 'true' if the triangle is valid, else 'false' .
III) Check if the dimensions entered by the user can form a valid triangle. (A triangle is valid if the length of each side is less than the sum of the lengths of the other two sides.)
Answer:
Exception Code:
The following code will check if a triangle is valid or not.
CREATE OR REPLACE FUNCTION triangle(a number,b number,c number) RETURN boolean AS invalid_triangle exception;
BEGIN IF NOT (a+b>=c
AND b+c>=a
AND c+a>=b) THEN RAISE invalid_triangle;
ELSE RETURN TRUE;
END IF;
exception WHEN invalid_triangle THEN dbms_output.put_line('xxxxxx- invalid triangle -xxxxxxxxxx');
RETURN FALSE;
WHEN others THEN dbms_output.put_line('un identified error occured');
END;
/
Calling Code:
DECLARE a number:=&side1;
b number:=&side2;
c number:=&side3;
x boolean;
BEGIN x:=triangle(a,b,c);
END;
/
Output:
