Home » SQL & PL/SQL » Client Tools » Report in SQLPLUS
Report in SQLPLUS [message #246661] Thu, 21 June 2007 10:26 Go to next message
Messages: 91
Registered: December 2005
Location: INDIA
Hi Guys,

In my sqlplus report i have set my ttitle as said below.I just want my sysdate to be displayed next to 'REPORT GENERATED ON <SYSDATE>'

ttitle 'Report generated on sysdate'

The above quoted is not working i.e. is not showing the sysdate,instead it is just printing sysdate string as such.

How can i do that?Any suggestions.


[Updated on: Thu, 21 June 2007 10:34]

Report message to a moderator

Re: Report in SQLPLUS [message #246691 is a reply to message #246661] Thu, 21 June 2007 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 63907
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at date display in report

Re: Report in SQLPLUS [message #246707 is a reply to message #246661] Thu, 21 June 2007 11:49 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
set verify off
COLUMN a new_val thisuser noprint
COLUMN b new_val todaysdate noprint
select USER a,
from dual;

spool mylog_&todaysdate..log

ttitle "This is my title &thisuser &todaysdate"

select 123 from dual;

prompt Logfile is mylog_&todaysdate..log
spool off

Connected to:
Oracle9i Enterprise Edition Release - 64bit Production
With the Partitioning option
JServer Release - Production

Thu Jun 21                                                             page    1
                      This is my title SCOTT 20070621_0947


Logfile is mylog_20070621_0947.log

Previous Topic: condition in SQL (merged)
Next Topic: not to display first two columns
Goto Forum:

Current Time: Thu Oct 20 19:58:08 CDT 2016

Total time taken to generate the page: 0.15473 seconds