DBA Data[Home] [Help]

SYS.DBMS_XMLQUERY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

    FOR i IN (select object_name, owner, timestamp
              from all_objects
              where object_name like '%XSU%VERSION%')
    LOOP
      DBMS_OUTPUT.PUT_LINE(RPAD(i.object_name,27) ||
                           RPAD(i.owner,14) || SUBSTR(i.timestamp,1,16));