update B set DESC=(select desc from A where A.name=B.name) where B.desc
IS null;

KAzi

Shadab Mehboob wrote:
> Dear MAsters
> I have two tables Table A and Table B
> Boith have teh same structure .
> Table A has data aand table B has data but for one column.
> I want to update Table B with Value of Table A for the column where Table B is null.
> I.e i have the Tables as
> A
> name code desc
> 1 ABC xyz
> 2 ABD XYY
> 3 ABE XXY
>
> in B i have
> name code desc
> 1 xyz abc
> 2 XYYdesc
> 3 XXY
>
> How do i make both table data identical for code
> Regards
> Shadab
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>


Oracle LazyDBA home page