select sct.obj#, sct.intcol#,
o.owner_name, o.name,
sct.toid,
t.version#,
sys.dbms_metadata.get_hashcode(o.owner_name,o.name),
t.typeid
from ku$_schemaobj_view o, type$ t, subcoltype$ sct
where o.oid=sct.toid and o.oid=t.toid
SELECT SCT.OBJ#
, SCT.INTCOL#
,
O.OWNER_NAME
, O.NAME
,
SCT.TOID
,
T.VERSION#
,
SYS.DBMS_METADATA.GET_HASHCODE(O.OWNER_NAME
, O.NAME)
,
T.TYPEID
FROM KU$_SCHEMAOBJ_VIEW O
, TYPE$ T
, SUBCOLTYPE$ SCT
WHERE O.OID=SCT.TOID
AND O.OID=T.TOID
|
|
|