Oracle PLSQL：从字符串中删除“空格字符”

Oracle PL/SQL：从字符串中删除“空格字符”

sql
CREATE OR REPLACE FUNCTION remove_spaces(p_string IN VARCHAR2) RETURN VARCHAR2 IS
    v_result VARCHAR2(4000);
BEGIN
    v_result := REPLACE(p_string, ' ', '');
    RETURN v_result;
END;
/

sql
DECLARE
    v_input VARCHAR2(4000) := 'Hello, World!';
    v_output VARCHAR2(4000);
BEGIN
    v_output := remove_spaces(v_input);
    DBMS_OUTPUT.PUT_LINE('Original String: ' || v_input);
    DBMS_OUTPUT.PUT_LINE('String without Spaces: ' || v_output);
END;
/