Featured

Apex 19.2 (ORDS) in tomcat Docker container

Update : 04 February 2020Instead of relying on having server.xml being pass as Docker build image step, I added a few environment variables for tomcat ports and use those environment variables to configured server.xml I got my base image from https://github.com/Dani3lSun/docker-db-apex-dev. His APEX docker image is for someone who wants to tried out APEX without … Continue reading Apex 19.2 (ORDS) in tomcat Docker container →

Simple Apex Apps using REST Data Services

Create Module Create Template Create Handler Following query will return RMAN Backup Duration in seconds format for latest RMAN job with backup_runs as ( select operation, status, object_type, start_time, end_time, to_char(start_time,'MM/DD/YYYY HH24:MI:SS') as char_start_time, to_char(end_time,'MM/DD/YYYY HH24:MI:SS') as char_end_time from v$rman_status where operation in ('RMAN','BACKUP') and OBJECT_TYPE like '%DB%' and STATUS = 'COMPLETED' and start_time = … Continue reading Simple Apex Apps using REST Data Services →