CREATE OR REPLACE FUNCTION Case_Adjustments(id IN VARCHAR2)
    RETURN VARCHAR2
IS
    details VARCHAR2(100);
BEGIN
    SELECT
        criminal.criminal_fname || ', ' ||criminal.criminal_sname || ' commited the offence ' || offence.offence_name || ' and has a new case date which is ' || (cases.case_date + 5) AS "info"
    INTO
        details
    FROM
        cases
    inner join CRIMINAL  ON criminal.criminal_id = CASES.criminal_id
    inner join OFFENCE ON offence.offence_id = CASES.offence_id
    WHERE cases.criminal_id = id;

    RETURN details;
END;
/
-- Calling the function...
DECLARE
    crime VARCHAR2(1000);
BEGIN
    crime := Case_Adjustments('crim101');
    DBMS_OUTPUT.PUT_LINE(crime);
END;