SELECT CU.TABLE_NAME,LISTAGG(CU.COLUMN_NAME,',') within group(order by cu.TABLE_NAME) as COLUMN_NAME FROM USER_CONS_COLUMNS CU, USER_CONSTRAINTS AU WHERE CU.CONSTRAINT_NAME = AU.CONSTRAINT_NAME AND AU.CONSTRAINT_TYPE = 'P' AND TABLE_NAME IN ('xxxxxx') GROUP BY CU.TABLE_NAME;