Re: Update Table

Serdal Tanriverdi wrote:

> Hi,
>
> i want to update Table A Col Ort_A with Ort_B from Table B. How can i
> resolve this prob ? I think a trigger or function can bee usefull - but
> i don't know how to code it. Can anyone help me ? We use Oracle Ent 9.2
> Version
>
> Big THX
>
>
> Table A
> --------------------------
> PLZ Ort
> --------------------------
> 01001 Bagnang
> 01002 ?
> 01003 Lauda
> ...... .....
> 99999 ?
>
>
> Table B
> --------------------------
> PLZ Ort
> --------------------------
> 01001 Bagnang
> 01002 Dollheim
> 01003 Lauda
> ...... .....
> 99999 Kissingen

I think we don't do people's homework assignments for them.

But why use a PL/SQL to do what can be done more readily with a simple DML statement?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)