Oracle in a Nutshell

Getting the date into a title

To get the current date into a page title, you must get the date into a user variable and then place the user variable into your BTITLE or TTITLE command.

You can use the following commands in a SQL*Plus script to get the current date into a user variable:

SET TERMOUT OFF
COLUMN curdate NEW_VALUE report_date
SELECT TO_CHAR(SYSDATE,'dd-Mon-yyyy') curdate
   FROM DUAL;
SET TERMOUT ON

After executing the commands shown here, the date will be in a user variable named REPORT_DATE. The following command places that value into a page footer:

BTITLE LEFT "Report Date: " report_date

This same technique can also be used to retrieve other values from the database and place them in either a page header or page footer.