December 2002
Intermediate to advanced
928 pages
85h 29m
English
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.