Search This Blog

Total Pageviews

Wednesday, 19 October 2011

Oracle sqlplus TTitle date

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 ) ***

Oracle DBA

anuj blog Archive