Generate UPDATE SQL without using LISTAGG()

multiline_update.sql

with col_info as (
select 
  c.owner,
  c.table_name,
  c.column_name,
  c.column_id,
  pc.column_name as PK_COL 
from
  all_tab_cols c join all_constraints p on
    c.owner = p.owner and
    c.table_name = p.table_name and 
    p.constraint_type = 'P'
  left join all_cons_columns pc on 
    p.constraint_name = pc.constraint_name and
    p.owner = pc.owner and
    c.column_name = pc.column_name
where
  c.owner = '#OWNER#' and
  c.table_name = '#TGT_TABLE#'
order by c.column_id
), col_clause as (
select
  column_name || ' = ORCHESTRATE.' || column_name as txt,
  nvl2(pk_col, 'Y', 'N') as is_pk,
  row_number() over (partition by nvl2(pk_col, 'Y', 'N') order by column_id) as row#,
  count(*) over (partition by nvl2(pk_col, 'Y', 'N')) as tot_row
from col_info
)
select 'UPDATE #TGT_TABLE# SET ' as txt from dual
union all
select
  '  ' || txt || case when row# <> tot_row then ',' else '' end
from col_clause
where is_pk = 'N'
union all
select 'WHERE ' from dual
union all
select
  '  ' || txt || case when row# <> tot_row then ' AND' else '' end
from col_clause
where is_pk = 'Y'