-- 达梦
SELECT
'INSERT INTO ' || TABLE_NAME || ' (' ||
LISTAGG(COLUMN_NAME, ', ') WITHIN GROUP (ORDER BY COLUMN_ID) || ') ' ||
'VALUES (' ||
LISTAGG(':' || REPLACE(INITCAP(REPLACE(LOWER(COLUMN_NAME), '_', ' ')), ' ', ''), ', ')
WITHIN GROUP (ORDER BY COLUMN_ID) || ');' AS insert_sql
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'your_table_name'
GROUP BY TABLE_NAME;