in_out_function

PHOTO EMBED

Sat Jun 08 2024 02:06:02 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

 CREATE OR REPLACE FUNCTION calculate_square (input_number IN NUMBER,output_result OUT NUMBER) RETURN NUMBER IS
BEGIN
    output_result := input_number * input_number;
    RETURN output_result;
END calculate_square;
/
DECLARE
    input_number NUMBER := 5;
    output_result NUMBER;
BEGIN
    output_result := NULL;
    output_result := calculate_square(input_number, output_result);

    DBMS_OUTPUT.PUT_LINE('Input number: ' || input_number);
    DBMS_OUTPUT.PUT_LINE('Square of the input number: ' || output_result);
END;
/
content_copyCOPY