WITH CUSTOMIZATION AS (
	SELECT
		UTC.TABLE_NAME AS TABLE_NAME
		, (SELECT COMMENTS FROM USER_TAB_COMMENTS WHERE TABLE_NAME = UTC.TABLE_NAME) AS TABLE_COMMENT
		, UTC.COLUMN_NAME AS COLUMN_NAME
        , LOWER(SUBSTR(UTC.COLUMN_NAME, 0, 1)) || SUBSTR(REPLACE(INITCAP(UTC.COLUMN_NAME), '_', ''), 2) AS PROPERTY_NAME
		, UTC.DATA_TYPE || '(' || UTC.DATA_LENGTH || ')' AS DATA_TYPE
		, UTC.DATA_DEFAULT
		, UTC.NULLABLE
		, CASE WHEN UCP.CONSTRAINT_NAME IS NOT NULL THEN 'PK' END AS PK
		, UCC.COMMENTS AS COLUMN_COMMENT
	FROM
		USER_TAB_COLUMNS UTC
		, USER_COL_COMMENTS UCC
		, (
			SELECT
				UCOC.TABLE_NAME
				, UCOC.COLUMN_NAME
				, UCOC.CONSTRAINT_NAME
			FROM
				USER_CONS_COLUMNS UCOC
				, USER_CONSTRAINTS UCO
			WHERE
				UCOC.CONSTRAINT_NAME = UCO.CONSTRAINT_NAME
			AND
				UCO.CONSTRAINT_TYPE = 'P'
		) UCP
	WHERE
		UTC.TABLE_NAME = UCC.TABLE_NAME
	AND
		UTC.COLUMN_NAME = UCC.COLUMN_NAME
    AND
    	UTC.TABLE_NAME = UCP.TABLE_NAME(+)
    AND
    	UTC.COLUMN_NAME = UCP.COLUMN_NAME(+)
	AND
		UTC.TABLE_NAME = '[TABLE_NAME]'
    ORDER BY
    	UTC.COLUMN_ID
)
SELECT * FROM CUSTOMIZATION;