Road To OCM
Showing posts with label
reporting
.
Show all posts
Showing posts with label
reporting
.
Show all posts
Saturday, July 28, 2012
How to print date on sqlplus report title
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
Older Posts
Home
Subscribe to:
Posts (Atom)