DBA Data[Home] [Help]

SYS.DBMS_XMLQUERY dependencies on ALL_OBJECTS

Line 13: from all_objects

9: DBMS_OUTPUT.PUT_LINE('-------------------------- ' ||
10: '------------- ----------------');
11:
12: FOR i IN (select object_name, owner, timestamp
13: from all_objects
14: where object_name like '%XSU%VERSION%')
15: LOOP
16: DBMS_OUTPUT.PUT_LINE(RPAD(i.object_name,27) ||
17: RPAD(i.owner,14) || SUBSTR(i.timestamp,1,16));