-
declare
a number ;
b number ;
x number ;
y number ;
c number ;
d date ;
z date ;
begin
a := 1;
b := a+1;
select shrfnbr into x from puneet_temp where serial = a;
select trunc(timestamp) into d from puneet_temp where serial = a;
select shrfnbr into y from puneet_temp where serial = b;
c:= y-x;
loop
select trunc(shrstmp) into z from shopper where shrfnbr =c;
if z <> d then
dbms_output.put_line ( c || ' ' || z);
end if;
exit when c < 8520 ;
c:=c-1;
end loop;
exception when no_data_found then
dbms_output.put_line ( c || ' ' || 'NODATA');
end;
/
-
check your DBA thread on this subject
