Click here to Skip to main content
15,915,702 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
how to identify commit rows in table in oracle


What I have tried:

select * from t2 minus select * from table_a as of scn 1168334;

SQL>
Posted
Updated 29-Jul-16 0:06am

1 solution

That is the correct way

SQL> create table example (a number);

Table created.

SQL> insert into example values (1);
SQL> insert into example values (2);
SQL> commit;

Commit complete.

SQL> insert into example values (3);

1 row created.

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
16432271

SQL> select * from example minus select * from example as of scn 16432271
;

A
----------
3

Another way, would be create new login session and do select count(*) from the table.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900