end of data

i have a sql which spool data of a table to a file. i want to print 'END OF DATA' as the last line in the file. what should i add in my sql file to get the above

Thanks

after the sql statement, do "Prompt END OF DATA"

Failing that if the data is character you could do UNION select 'END OF DATA' from dual but thats a bit grubby...