BEGIN
    Name VARCHAR2(200);
    SELECT
        uid,
        nickname INTO Name,
        IF Name := NULL THEN
            name;
        ELSE
            name || ' (' || nickname || ')';
        END IF; AS Name,
        phonenumber
    FROM
        employees
END;
/