Hello Experts,
I want to display the count of records from SYS_REFCURSOR , to be more precise with my requirement, I need to send the count of status , age and type individually to Java application.
select * from ABC
where ABC_id = 2001
and ABC_LEVEL_ID = 1 --status
and ABC_REQUEST_DATE < sysdate --age
and ABC_TYPE_ID = 5; --type