9.41 OPG_APIS.GET_SCN
Format
OPG_APIS.GET_SCN() RETURN NUMBER;
Description
Returns the SCN (system change number) of the Oracle Spatial and Graph property graph support, in YYYYMMDD format.
Note:
Effective with Release 20.3, the OPG_APIS.GET_SCN function is deprecated. Instead, to retrieve the current SCN (system change number), use the DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function:SELECT dbms_flashback.get_system_change_number FROM DUAL;
Parameters
(None.)
Usage Notes
The SCN value is incremented after each commit.
Examples
The following example returns the current build ID of the Oracle Spatial and Graph property graph support.
SQL> SELECT OPG_APIS.GET_SCN() FROM DUAL; OPG_APIS.GET_SCN() ------------------ 1478701
Parent topic: OPG_APIS Package Subprograms