How to print date on sqlplus report ?
print date in report
COLUMN report_date_col NEW_VALUE report_date
col report_date_col noprint
SELECT TO_CHAR ( SYSDATE ,'DD-Mon-YYYY:HH:MI') AS report_date_col FROM dual;
TTitle left "*** Rollback Information ( Date: &report_date ) ***" skip 2
output will be like this
*** Rollback Information ( Date: 19-Oct-2011:12:36 ) ***
Search This Blog
Total Pageviews
Wednesday, 19 October 2011
Subscribe to:
Posts (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)