SET TIME in SQL* Plus

  ** Email to info@shreyantech.com to get the Tip of the Day in your mailbox.

SET TIME in SQL* Plus   ( Watch the Video Version )

SET TIME: Controls the Display of current time before the SQL Prompt.

Syntax: SET TIME {ON | OFF}

ON - Displays the time before each SQL command prompt.

OFF - Disables the display of Time before each SQL Command Prompt. OFF is the Default.

Example:

SQL>

SQL> show time

time OFF

SQL> SET TIME ON

12:55:22 SQL>

12:55:59 SQL> SET TIME OFF

SQL>

SQL>

=======================================================================