oracle-audit-trigger-003.sql

     table_agg_stg
         AS (SELECT trigger_sql,
                    table_name,
                    listagg (
                        'audtab.' || column_name || ':= :NEW.' || column_name,
                        '; ')
                    WITHIN GROUP (ORDER BY column_id)
                        insert_column_list,
                    listagg (
                        'audtab.' || column_name || ':= :OLD.' || column_name,
                        '; ')
                    WITHIN GROUP (ORDER BY column_id)
                        update_column_list
               FROM table_columns_stg
             GROUP BY trigger_sql, table_name)