How we can set Date and Time on command line in sqlplus while working not on server i.e on standalone PC

Views: 41

Replies to This Discussion

Hope this helps.

==
C:\Documents and Settings\jmunshi>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jul 26 10:18:14 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> set time on
10:18:18 SQL>

Hi,

not clear what you exactly want..

you can also try the way

 

SET SQLPROMPT "_DATE _USER> "

RSS

Oracle Jobs in US

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service