Hi
Iam using oracle 8.1.7.4.
What is the SQL statement to find the last SCN and associated time stamp for the last transaction.
Thanks in advance
With Regards
Vara Prasad
Hi
Iam using oracle 8.1.7.4.
What is the SQL statement to find the last SCN and associated time stamp for the last transaction.
Thanks in advance
With Regards
Vara Prasad
What do you do with the LAST SCN?
SQL> select dbms_flashback.get_system_change_number
from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
78305974
Tamil
DBMS_FLASHBACK in 8.1.7 ? :confused:
Sorry I did not see the Oracle release.
Tamil