SQL*Plus isn’t known for its report-writing capabilities. But there are a few tricks you can use to spiff up the output of your PL/SQL queries. One of these tricks is setting automatic titles for your output. This can be done
Oracle Home
For Everything Oracle and more