SQL*Plus Command: "Set time on"

[RobertK]

I put "set time on" in Login.sql:

--------------------------------------------
1024:37i:12 NOT CONNECTED>
1024:37i:18 MR_FOO@TEST10>
1024:37i:21 MR_FOO@TEST10> select to_char(systimestamp,'yy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSTIMESTAMP,'YY-MM-DD
------------------------------
08-09-12 10:47:40

1024:39i:26 MR_FOO@TEST10>

--------------------------------------------------

I don't see "set time on" in the manual so I'm guessing it is officially not supported.

Is there anyway to format the displayed timestamp ??

1024:37i:18 MR_FOO@TEST10>

thanks

 

[Marco van der Linden]

just of the top of my head, but shouldn't it be set timING on'?

 

[RobertK]

Originally posted by Marco van der Linden:
just of the top of my head, but shouldn't it be set timING on'?

set time [on/off] set timing [on/off]

 

[Gustavo]

"set time" will add prompt generation date/time to the prompt itself.
"set timing" shows the elapsed time for the last operation.