17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FORCE VIEW SYSTEM.VDICT_USER_TABLE_LIST (OBJECT_ID, COMMENTS, TABLE_NAME)
AS
SELECT DISTINCT OBJECT_ID,
COMMENTS,
TABLE_NAME
FROM SYS.DBA_TAB_COMMENTS T1
INNER JOIN SYS.USER_OBJECTS T2
ON T1.TABLE_NAME=T2.OBJECT_NAME
INNER JOIN sys.USER_TABLES T3
ON T3.TABLE_NAME=T1.TABLE_NAME
WHERE T1.TABLE_TYPE='TABLE'
WITH READ ONLY