reporting using pl/sql package - add line if no employees to report
I have a package that I have written in pl/sql that runs from a concurrent request in Oracle. It reports average hours employees work within 26 pay periods. It reports the store, employee name, and the hours. I want to report only those employees who have anniversaries within a specific time period. Some stores may not have employees to report and if so, I want to output a message for those that says, no employees to report. But not sure how to do it.
Anyone have any ideas?
Tagged:
0