December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_FLASHBACK.ENABLE_AT_TIME
(query_time IN TIMESTAMP);
Enables flashback mode for the entire session for snapshot at query_time.
PROCEDURE DBMS_FLASHBACK.ENABLE_AT_SYSTEM_CHANGE_NUMBER
(query_scn IN NUMBER);
Enables flashback mode for the entire session for snapshot at query_scn.
FUNCTION DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER( )
RETURN NUMBER;
Returns current SCN for later use.
PROCEDURE DBMS_FLASHBACK.DISABLE;
Disables flashback mode for entire session.