One popular method which allows you to customize only the "no rows selected" feedback message is described at these pages.
OTN Discussion Forum - no rows selected ...
OraFAQ Forum: SQL & PL/SQL Newbies => sql*plus Report
A performance comparison between this method and the SQL Snippets technique presented in Changing the Footer is available at the end of this log file.
