Skip to Main Content
Oracle APEX 24.2 Internal Table Defragmentation Oracle APEX and DGX Spark Clusters.

APEX Troubleshooting

APEX
APEX Troubleshooting

-- Uploaded Files to APEX

SELECT
   filename,
   description,
   TO_CHAR(MAX(created_on), 'YYYY-MM-DD HH24:MI:SS') AS created_on
FROM apex_application_files
WHERE created_on IS NOT NULL
 AND REGEXP_LIKE(filename, '^f.*\.zip$', 'i')
GROUP BY filename, description
ORDER BY 3 DESC;