Guys-

Is there any better way to write the below update
statment, using in-line view.


update ia_agreements a
set a.AGRMT_TYPE_ID = (select t.AGRMT_TYPE_ID from
temp_ia_agreements t where t.ext_id = a.ext_id),
a.ITD_GROSS_SURRENDER = (select
t.ITD_GROSS_SURRENDER from temp_ia_agreements t where
t.ext_id = a.ext_id),
a.ITD_GROSS_PREMUIM = (select t.ITD_GROSS_PREMUIM
from temp_ia_agreements t where t.ext_id = a.ext_id),
a.ITD_EV_CREDIT = (select t.ITD_EV_CREDIT from
temp_ia_agreements t where t.ext_id = a.ext_id),
a.ITD_EV_FORFIETURE = (select t.ITD_EV_FORFIETURE
from temp_ia_agreements t where t.ext_id = a.ext_id),
a.BENE_PROTECT_BASIS_AMT = (select
t.BENE_PROTECT_BASIS_AMT from temp_ia_agreements t
where t.ext_id =
a.ext_id)

Thanks
Goutam

=====
Thanks
Praveen Siddavarapu
www.siddavarapu.com

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Oracle LazyDBA home page