update bmp_client t set t.firmcode=(
select c.licensecode
from clt_clt_info@biz_dblink.regress.rdbms.dev.us.oracle.com c where t.client_no=c.cltno
)
update bmp_client t set t.firmcode=(
select c.licensecode
from clt_clt_info@biz_dblink.regress.rdbms.dev.us.oracle.com c where t.client_no=c.cltno
)