Available inPSQL

TypeBOOLEAN

Syntax

  |RESETTING

Available in triggers only, RESETTING indicates if the trigger fired during a session reset. Its value is TRUE if session reset is in progress and FALSE otherwise. Intended for use in ON DISCONNECT and ON CONNECT database triggers to detect an ALTER SESSION RESET.