|
|
Re: How to use sysdate as a column header [message #676869 is a reply to message #676867] |
Wed, 24 July 2019 11:45 |
Solomon Yakobson
Messages: 3273 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Column header is displayed by the tool you are using, not by SQL engine. For example, you can use predefined substitution variable _DATE, if you use SQL*Plus:
SQL> COLUMN DT HEAD "&&_DATE"
SQL> SELECT 'Check column header for today''s date' DT
2 FROM DUAL
3 /
24-JUL-19
------------------------------------
Check column header for today's date
SQL>
SY.
|
|
|
Re: How to use sysdate as a column header [message #676879 is a reply to message #676869] |
Wed, 24 July 2019 23:33 |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Thank you Solomon Yakobson,
You derived result as i need, but i need to pass this query through java resultset so setting up column header which you advised is not feasible. Therefore, i requested sysdate in column header.
Thanks,
Chintan
|
|
|
|
|