Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLPLUS, timestamp as prompt

GlassFacetMar 12 2011 — edited Mar 12 2011
Is there any way to get the time in sqlprompt without altering nls_date_format.

If I change nls_date_format some queries are failing which use the regular date and time format.

Even any other SQL tool, preferebly console version would also work.
This post has been answered by Peter Gjelstrup on Mar 12 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2011
Added on Mar 12 2011
#general-database-discussions
5 comments
9,614 views