select '1','0',
cm.obj#, value(o),
(select t.property from sys.tab$ t where t.obj#=cm.obj#),
cm.col#,
(select c.name
from sys.col$ c
where c.obj#=cm.obj# and c.intcol# = cm.col# ),
TO_CLOB(replace(cm.comment$,'''',''''''))
from sys.ku$_edition_schemaobj_view o,
sys.com$ cm
where o.obj_num = cm.obj# AND cm.comment$ is not null AND
(SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '0'
,
CM.OBJ#
, VALUE(O)
,
(SELECT T.PROPERTY
FROM SYS.TAB$ T
WHERE T.OBJ#=CM.OBJ#)
,
CM.COL#
,
(SELECT C.NAME
FROM SYS.COL$ C
WHERE C.OBJ#=CM.OBJ#
AND C.INTCOL# = CM.COL# )
,
TO_CLOB(REPLACE(CM.COMMENT$
, ''''
, ''''''))
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
,
SYS.COM$ CM
WHERE O.OBJ_NUM = CM.OBJ#
AND CM.COMMENT$ IS NOT NULL AND
(SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|