Hi,
I have a simple question about a pl/sql as following:
update mail_out pmo
set pmo.subdivision = (
select gd.subdivision
from gis_data gd
where pmo.apn_9 = gd.apn);
When I run it from SQL*Plus, it seems run forever and I can't get any results. Can someone give me some suggestions?
Thanks
Xuewei
I have a simple question about a pl/sql as following:
update mail_out pmo
set pmo.subdivision = (
select gd.subdivision
from gis_data gd
where pmo.apn_9 = gd.apn);
When I run it from SQL*Plus, it seems run forever and I can't get any results. Can someone give me some suggestions?
Thanks
Xuewei