DBA Data[Home] [Help]

OLAPSYS.OLAPDIMVIEW dependencies on ALL_MVIEWS

Line 224: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS

220: -- and b.measure_name = c.measure_name
221: -- and a.owner = eOwnerName
222: -- and a.cube_name = eCubeName;
223:
224: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS
225: where owner= eOwnerName
226: and QUERY_LEN= query_length;
227:
228:

Line 1921: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS

1917: -- and b.measure_name = c.measure_name
1918: -- and a.owner = eOwnerName
1919: -- and a.cube_name = eCubeName;
1920:
1921: CURSOR checkName IS SELECT QUERY from ALL_MVIEWS
1922: where owner= eOwnerName
1923: and QUERY_LEN= query_length;
1924:
1925: