How to get sqlplus to print current date/time
27785Jan 16 2002 — edited Mar 29 2007From a unix command line I can type:
prompt> date; <any_Cmd>; date
This will result in a timestamp being output before and after the command you inserted. Is there a way to make sqlplus print the current date/time after it is done executing an sql statment. This would be useful for me to know how long it took to execute and sql statement without watching it.
Something like:
SQL> select * from table; date;