How we can set Date and Time on command line in sqlplus while working not on server i.e on standalone PC
Hope this helps.
C:\Documents and Settings\jmunshi>sqlplus /nolog
SQL*Plus: Release 18.104.22.168.0 Production on Wed Jul 3 17:18:14 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> set time on
not clear what you exactly want..
you can also try the way
SET SQLPROMPT "_DATE _USER> "