end of data

[programmer]

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

[bmycroft]

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...