Suppose I had created one view or package in scott schema and after two days i have changed some coding in a view or package.
Now i want to restore the coding of view or package at the time of creation. like below
A)
create or replace view v1 as
select 1 a from dual;
B)
after two days
create or replace view v1 as
select 1 a,2 b from dual;
Now i want to restore A) part coding.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi