Database Reference
In-Depth Information
AND (TO_NUMBER(SUBSTR(TO_CHAR(UPDATED_TIME-CREATED_TIME),12,2))*60*60) + (TO_NUMBER(SUBSTR(TO_CHAR(UPDATED_TIME-CREATED_TIME),15,2))*60) + TO_NUMBER(SUBSTR(TO_CHAR(UPDATED_TIME-CREATED_TIME),18,4)) > 10
-- AND COMPONENT_NAME LIKE '%%'
ORDER BY COMPONENT_NAME, CREATION_DATE
You can further limit the query to a specific component, but it must be within the
LIKE
clause. The following screenshot shows the output of the preceding query.
Once again, we can now navigate to the particular composite instance ID for fur-
ther investigation.
