Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET TIME — Not available in iSQL*Plus

Synopsis

The TIME setting controls whether SQL*Plus displays the current time with each command prompt.

Syntax

SET TI[ME] {OFF | ON}

Parameters

SET TI[ME]

Is the command, which may be abbreviated SET TI.

OFF

Keeps the time from being displayed with the prompt. This is the default setting.

ON

Causes the time to be displayed as part of each prompt.

Examples

The following example shows the effect of issuing a SET TIME ON command:

SQL> SET TIME ON
22:44:41 SQL>