Tuesday, July 25, 2017

SQL to get count of composites in SOA 11g

This SQL will give count of compostes create each day for last 31 days:


select composite_name,domain_name,trunc(creation_date) creation_date,count(*) Instance_Count
FROM prod_soainfra.cube_instance
WHERE trunc(CREATION_DATE)>=trunc(sysdate-31)
group by composite_name, domain_name, trunc(creation_date)
order by trunc(creation_date)

No comments:

Post a Comment