--------创建存储过程-------
create or replace procedure TestSP
as
begin
update table_name set CREATE_TIMESTAMP= sysdate-1 where id =2;
end;
testing
BEGIN
TESTSP();
--rollback;
END;
create or replace procedure TestSP
as
begin
update table_name set CREATE_TIMESTAMP= sysdate-1 where id =2;
end;
testing
BEGIN
TESTSP();
--rollback;
END;