finding Difference in pl/sql

[cheguashwini]

Hi
I have a problem.
I have two tables...table1 and table2.
table1 has the column latitude and sno(serial number) and table2 has the column lat and sno(serial number) .
i have to find the difference of all the values in column latitude from table 1 with all the values in column lat from table 2 and place it in a new table result having column difference

i have written this code but i am getting error as missing elements. Can anyone please guide me?
[code=oracle]
DECLARE
NO INTEGER :=1;
NUM INTEGER :=1;
BEGIN
for no in 1..10 loop
for Num in 1..10 loop
insert into result (difference) select (select T1.latitude from table1 T1 where sno=no - select T2.table2 from table2 T2 where sno=Num ) from table1 T1, table2 T2 ;
end loop;
end loop;
END;[/code]

Please help me in debugging this....
thanks a lot
Ashwini

[debasisdas]

Try to use cursor for the purpose.

[subashsavji]

[code=oracle]

DECLARE
NO INTEGER :=1;
NUM INTEGER :=1;
BEGIN
FOR no IN 10..10 LOOP
FOR Num IN 10..10 LOOP
INSERT INTO result (difference)
VALUES((SELECT T1.DEPTNO FROM DEPT T1 WHERE DEPTNO=no) - (SELECT T2.DEPTNO FROM DEPT T2
WHERE DEPTNO=Num )) ;
END LOOP;
END LOOP;
END;
/

[/code]

[subashsavji]

[code=oracle]

DECLARE
NO INTEGER :=1;
NUM INTEGER :=1;
BEGIN
FOR no IN 1..10 LOOP
FOR Num IN 1..10 LOOP
INSERT INTO result (difference)
VALUES((SELECT T1.latitude FROM table1 T1 WHERE sno=no) - (SELECT T2.LAT FROM table2 T2 WHERE s
END LOOP;
END LOOP;
END;
/

[/code]