SELECT OBJECT_NAME,COMMENTS,TABLE_DDL FROM (
SELECT
ROW_NUMBER() OVER(PARTITION BY OBJECT_NAME ORDER BY COMMENTS) XH,
U.OBJECT_NAME OBJECT_NAME,
C.COMMENTS COMMENTS,
DBMS_METADATA.GET_DDL(U.OBJECT_TYPE,U.OBJECT_NAME,'--用户名,可以不填') TABLE_DDL
FROM USER_OBJECTS U LEFT JOIN ALL_TAB_COMMENTS C ON U.OBJECT_NAME=C.TABLE_NAME
WHERE
U.OBJECT_TYPE IN('TABLE')
AND U.OBJECT_NAME LIKE '%--表名%')
WHERE XH=1