select '1','0',
o.obj_num,
value(o),
sys.dbms_metadata.get_prepost_table_act
(e.prepost, o.owner_name, o.name)
from sys.ku$_schemaobj_view o,
sys.tab$ t,
ku$_expact_view e
where o.obj_num = t.obj#
and e.prepost=2
and e.owner=o.owner_name and e.name=o.name
SELECT '1'
, '0'
,
O.OBJ_NUM
,
VALUE(O)
,
SYS.DBMS_METADATA.GET_PREPOST_TABLE_ACT
(E.PREPOST
, O.OWNER_NAME
, O.NAME)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
,
SYS.TAB$ T
,
KU$_EXPACT_VIEW E
WHERE O.OBJ_NUM = T.OBJ#
AND E.PREPOST=2
AND E.OWNER=O.OWNER_NAME
AND E.NAME=O.NAME
|
|
|