Oracle Consultants

173 members

Description

Promote your Oracle talent and knowledge and share it with Oracle Consultants group. Grow, learn and interact with Oracle people to network with Oracle community

Comments Discussions Members

SQLPlus

by Billi Borum

Jul 26, 2013

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

  • up

    Mirtha Steakley

    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>

    Jul 26, 2013

  • up

    Shyla Aye

    Hi,

    not clear what you exactly want..

    you can also try the way

     

    SET SQLPROMPT "_DATE _USER> "

    Jul 26, 2013