How to set date time output in sqlplus
Sometimes it is useful to check report runtime via sqlplus when you have a date timestamp . It can be set by set time on command.thru sqlplus command prompt .
SQL> set time on
11:33:30 SQL> set sqlprompt >
SQL> set time on
11:30:01 SQL>
11:33:30 SQL>
also, you may omit SQL prompt perfix entry
11:33:30 SQL> set sqlprompt >
11:33:37 >
11:33:38 >
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment