I having a report ABC which i need to run every day. my client asked us to display time duration between last run-time and present run-time in the report.
Ex:- Yesterday - 2013/10/8 12:00:00
Today - 2013/10/9 04:00:00
Result - 1 Day, 4 Hours, 00 Minuets
please tell me how display this time duration value in the report.
You'll have to have Usage Tracking enabled in order to get this information. The information is stored in S_NQ_ACCT in the BIPLATFORM schema (assuming you're on 11g obviously...).