oracle apex elapsed time

Solutions on MaxInterview for oracle apex elapsed time by the best coders in the world

showing results for - "oracle apex elapsed time"
Ivanna
22 Feb 2019
1SELECT ELAPSED_TIME, numtodsinterval(ELAPSED_TIME, 'second') IV,
2       extract(MINUTE FROM numtodsinterval(ELAPSED_TIME, 'second')) MI,
3       extract(SECOND FROM numtodsinterval(ELAPSED_TIME, 'second')) SS
4FROM APEX_WORKSPACE_ACTIVITY_LOG 
5WHERE WORKSPACE = 'wks_name'
6    AND APEX_USER = 'user_name'
7    AND APPLICATION_ID = 'app_id';