Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DECLARE
  v_owner VARCHAR2(50) := user; -- 'LFS_SURVEY'; -- Replace with your schema/owner name
  v_table_name VARCHAR2(50) := 'LFS_FAMILY_TAB'; -- Replace with your table name
  v_rp_ids VARCHAR2(100) := '2030, 2031'; -- Replace with your RP_ID values
  v_columns CLOB;
  v_query   CLOB;
BEGIN
  -- Get all column names with transformations based on data type
  SELECT RTRIM(x.str, ', ')
  INTO v_columns
  FROM (
    SELECT XMLELEMENT(r, XMLAGG(XMLELEMENT(e, 
      CASE 
        WHEN COLUMN_NAME = 'F_M_ID'
        THEN 'TO_CHAR(t.F_M_ID) AS F_M_ID'
        WHEN DATA_TYPE LIKE '%CHAR%'
        THEN 'REPLACE(REPLACE(t.' || COLUMN_NAME || ', CHR(13), ''''), CHR(10), '''') AS ' || COLUMN_NAME
        ELSE 't.' || COLUMN_NAME 
      END || ', ') ORDER BY COLUMN_ID)) AS xmlx
    FROM ALL_TAB_COLUMNS
    WHERE TABLE_NAME = v_table_name
    AND OWNER = v_owner
  ) atc
  CROSS JOIN XMLTABLE(
    '/R'
    PASSING atc.xmlx
    COLUMNS str CLOB PATH '.'
  ) x;
  DBMS_OUTPUT.PUT_LINE(v_columns);
END;
/

1 rows affected

dbms_output:
TO_CHAR(t.F_M_ID) AS F_M_ID, t.FOO, REPLACE(REPLACE(t.BAR, CHR(13), ''), CHR(10), '') AS BAR