we can get the last updated date based on the following inbuild function:
Example:
create table Test_last_upd
(a number,
b varchar2(3)
);
begin
insert into Test_last_upd values (1,'AAA');
insert into Test_last_upd values (2,'BBB');
insert into Test_last_upd values (3,'CCC');
end;
update Test_last_upd
set b = 'ABC'
where a =3;
select TLU.*, scn_to_timestamp(max(ora_rowscn))
from Test_last_upd TLU
group by a,b;
scn_to_timestamp(max(ora_rowscn))
Example:
create table Test_last_upd
(a number,
b varchar2(3)
);
begin
insert into Test_last_upd values (1,'AAA');
insert into Test_last_upd values (2,'BBB');
insert into Test_last_upd values (3,'CCC');
end;
update Test_last_upd
set b = 'ABC'
where a =3;
select TLU.*, scn_to_timestamp(max(ora_rowscn))
from Test_last_upd TLU
group by a,b;
0 comments:
Post a Comment