Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table LFS_FAMILY_TAB (f_m_id number, foo date, bar varchar2(30))
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
EXECUTE IMMEDIATE 'SELECT RTRIM(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 || '', '').EXTRACT(''//text()'') ORDER BY COLUMN_ID).GETCLOBVAL(), '', '') 
    FROM ALL_TAB_COLUMNS 
    WHERE TABLE_NAME = ''' || v_table_name || ''' 
    AND OWNER = ''' || v_owner || '''' 
    INTO v_columns;
  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), &apos;), CHR(10), &apos;) AS BAR

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
EXECUTE IMMEDIATE 'SELECT RTRIM(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), null), CHR(10), null) AS '' || COLUMN_NAME
      ELSE ''t.'' || COLUMN_NAME 
    END || '', '').EXTRACT(''//text()'') ORDER BY COLUMN_ID).GETCLOBVAL(), '', '') 
    FROM ALL_TAB_COLUMNS 
    WHERE TABLE_NAME = ''' || v_table_name || ''' 
    AND OWNER = ''' || v_owner || '''' 
    INTO v_columns;
  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), null), CHR(10), null) AS BAR

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(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), null), CHR(10), null) AS ' || COLUMN_NAME
      ELSE 't.' || COLUMN_NAME 
    END || ', ').EXTRACT('//text()') ORDER BY COLUMN_ID).GETCLOBVAL(), ', ') 
  INTO v_columns
  FROM ALL_TAB_COLUMNS 
  WHERE TABLE_NAME = v_table_name
  AND OWNER = v_owner;
  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), null), CHR(10), null) AS BAR