E-learn Weblog of Willem van Valkenburg

SELECT OWNER_USERS_PK1, COUNT(OWNER_USERS_PK1)

FROM BB_BB60.PFLIO

GROUP BY OWNER_USERS_PK1

SELECT BB_BB60.PFLIO.TITLE, FIRSTNAME, BB_BB60.USERS.lastname, BB_BB60.USERS.USER_ID

FROM BB_BB60.PFLIO, BB_BB60.USERS

WHERE BB_BB60.PFLIO.OWNER_USERS_PK1 = BB_BB60.USERS.PK1

ORDER BY BB_BB60.USERS.USER_ID

SELECT CMS_FILES_USERS.XYF_URLS.FULL_PATH, CMS_FILES_USERS.XYF_FILES.Quota, CMS_FILES_USERS.XYF_FILES.File_size

FROM CMS_FILES_USERS.xyf_URLS, CMS_FILES_USERS.XYF_FILES WHERE CMS_FILES_USERS.xyf_URLS.file_id=CMS_FILES_USERS.xyf_FILES.file_id AND FILE_TYPE_CODE = 'D' AND CMS_FILES_USERS.xyf_URLS.parent_id='1001'

DELETE FROM queued_tasks WHERE status = 'C' AND end_date < sysdate-7;
COMMIT;