APEX Dashboard

APEX Dashboard

Code:

select label, to_char(value,'999G999G990') val, url
from (
select 1 display_order,
'STUDENT' label,
count(ADMISSION_NO) value,
'f?p='||:APP_ID||':1:'||:APP_SESSION||':::1,RIR,RP' url
from NEW_ADMISSION
union all

select 2 display_order,
'EMPLOYEE' label,
count(EMPLOYEE_ID) value,
'f?p='||:APP_ID||':45:'||:APP_SESSION||':::45,RIR,RP' url
from  EMPLOYEE_INFORMATION
union all
select 3 display_order,
'HOSTEL' label,
count(CHIT_NO) value,
'f?p='||:APP_ID||':45:'||:APP_SESSION||':::45,RIR,RP' url
from ROOM_BOOKING

union all
select 4 display_order,
'LIBRARY' label,
count(STORE_NO) value,
'f?p='||:APP_ID||':45:'||:APP_SESSION||':::45,RIR,RP' url
from BOOK_STORE
)

order by display_order


Output: