DBA Data[Home] [Help]

SYS.DBMS_FEATURE_ZMAP dependencies on CLSTKEY$

Line 40: '"clst_grp":' || (SELECT COUNT(DISTINCT groupid) FROM clstkey$ k

36: '"clst_type":"' || DECODE(clstfunc,1,'I','L') || '",'||
37: '"clst_mode":"' || DECODE(bitand(xx.cflags,1+2),1+2,'L+M',1,'L',2,'M','OFF') || '",'||
38: '"clst_dim":' || (SELECT COUNT(*) FROM clstdimension$ d
39: WHERE d.clstobj#(+)=xx.clstobj#) || ','||
40: '"clst_grp":' || (SELECT COUNT(DISTINCT groupid) FROM clstkey$ k
41: WHERE k.clstobj#(+)=xx.clstobj#) || ','||
42: '"clst_cols":' || (SELECT COUNT(*) FROM clstkey$ k
43: WHERE k.clstobj#(+)=xx.clstobj#) || ','||
44: '"clst_invalid":"' || DECODE(bitand(xx.flags,4),4,'Y','N') || '"},'

Line 42: '"clst_cols":' || (SELECT COUNT(*) FROM clstkey$ k

38: '"clst_dim":' || (SELECT COUNT(*) FROM clstdimension$ d
39: WHERE d.clstobj#(+)=xx.clstobj#) || ','||
40: '"clst_grp":' || (SELECT COUNT(DISTINCT groupid) FROM clstkey$ k
41: WHERE k.clstobj#(+)=xx.clstobj#) || ','||
42: '"clst_cols":' || (SELECT COUNT(*) FROM clstkey$ k
43: WHERE k.clstobj#(+)=xx.clstobj#) || ','||
44: '"clst_invalid":"' || DECODE(bitand(xx.flags,4),4,'Y','N') || '"},'
45: END ||
46: '"tab":{' ||