Finding SCN


select
to_char(
dbms_flashback.get_system_change_number, 'xxxxxxxxxxx') curr_scn_hex,
dbms_flashback.get_system_change_number curr_scn_dec
from dual;

CURR_SCN_HEX CURR_SCN_DEC
———— ————
52157e    5379454

About the author

Leave a Reply