Chapter 12. DBMS_FLASHBACK

Table of Contents

12.1. Overview
12.2. Procedure
12.2.1. GET_SYSTEM_CHANGE_NUMBER

This chapter briefly introduces the DBMS_FLASHBACK package, and describes how to use the procedure of the package.

12.1. Overview

DBMS_FLASHBACK currently only implements the GET_SYSTEM_CHANGE_NUMBER function. In future releases, it is planned to add management functions for the FLASHBACK mode.

12.2. Procedure

12.2.1. GET_SYSTEM_CHANGE_NUMBER

Returns the current Database TSN.

Details about the GET_SYSTEM_CHANGE_NUMBER procedure are as follows:

  • Prototype

    DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER
  • Example

    DECLARE tsn NUMBER; BEGIN tsn
              := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER; END; /