elapsed time in sqlplus client

Hi

SQL> select * from dual;

D
-
X

real: 16
SQL>

what i need is the elapsed time.I also tried setting set timing on no use any ideas ?

regards
Hrishy

"set timing on" works ... you probably have a mismatch between your client and server versions.

Hi Dave

Yep you are absolutely right :-)

regards
Hrishy

Quote:

---

Originally Posted by hrishy

SQL> select * from dual;

D
-
X

real: 16
SQL>

---

Wow, I remember when SQL*Plus used to give that type of timing info. Just. Version 8.0 or so, maybe?

Presumably you also encounter problems with timestamp columns and SQL commands beginning with MERGE or WITH as well.