Oracle DBMS_TRANSACTION_INTERNAL_SYS
Version 11.2.0.2
 
General Information
Source {ORACLE_HOME}/rdbms/admin/prvthtxn.plb
Dependencies Only STANDARD
Security Model Owned by SYS with no privileges granted
 
GET_CURRENT_SCN
Returns the current System Change Number dbms_transaction_internal_sys.get_current_scn;
SELECT dbms_flashback.get_system_change_number, dbms_transaction_internal_sys.get_current_scn, current_scn
FROM dual, v$database;
 
Related Topics
DBMS_FLASHBACK
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: © 2012 Daniel A. Morgan All Rights Reserved