DBA Data[Home] [Help]

OLAPSYS.OLAPFACTVIEW dependencies on ALL_MVIEWS

Line 218: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS

214: and b.measure_name = c.measure_name
215: and a.owner = eOwnerName
216: and a.cube_name = eCubeName;
217:
218: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS
219: where owner= eOwnerName
220: and QUERY_LEN= query_length;
221:
222:

Line 1976: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS

1972: and b.measure_name = c.measure_name
1973: and a.owner = eOwnerName
1974: and a.cube_name = eCubeName;
1975:
1976: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS
1977: where owner= eOwnerName
1978: and QUERY_LEN= query_length;
1979:
1980: