Road To OCM
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
1 comment:
Buddyroe
April 30, 2019 at 7:43 AM
Thank you. This helped me a lot just now.
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Thank you. This helped me a lot just now.
ReplyDelete