--- SQL operation complete.

SQL>

INSERT INTO COURSE1 VALUES

+>

('C11',

'INTRO TO CS','FOR ROOKIES',3, 100,'CIS');

--- 1 row(s)

inserted.

SQL>

INSERT INTO COURSE1 VALUES

+>

('C55', 'COMPUTER ARCH.','VON NEUMANN''S MACH.',3, 100, 'CIS');

--- 1 row(s)

inserted.

SQL> history;

1> show histopt

2> obey e:\scripts\nobey\insert2.sql

This SET HISTOPT command shows all the commands added to the history buffer.

SQL> set histopt all

SQL> obey e:\scripts\nobey\insert2.sql

?section insert

SQL> set schema neo.sch;

--- SQL operation complete.

SQL>

INSERT INTO COURSE1 VALUES

+>

('C11','INTRO TO CS','FOR ROOKIES',3, 100, 'CIS');

---1 row(s) inserted.

SQL> INSERT INTO COURSE1 VALUES

+>

('C55','COMPUTER ARCH.','VON NEUMANN''S MACH.',3,100,'CIS');

---1 row(s) inserted.

SQL> history;

1>

show histopt

2>

obey e:\scripts\nobey\insert2.sql

3>

history;

4>

set histopt all

5>

set schema neo.sch;

6>

INSERT INTO COURSE1 VALUES

 

('C11','INTRO TO CS','FOR ROOKIES',3, 100, 'CIS');

7>

INSERT INTO COURSE1 VALUES

('C55','COMPUTER ARCH.','VON NEUMANN''S MACH.',3,100,'CIS');

SET IDLETIMEOUT Command

The SET IDLETIMEOUT command sets the idle timeout value for the current session. The idle timeout value of a session determines when the session expires after a period of inactivity. The default is 30 minutes.

Syntax

SET IDLETIMEOUT value

value is an integer representing the idle timeout value in minutes. Zero represents an infinite amount of time, meaning that the session never expires.

SET IDLETIMEOUT Command 103