Update Table

From: Serdal Tanriverdi <s.tanriverdi_at_arcor.de>
Date: Fri, 15 Oct 2004 01:55:09 +0200
Message-ID: <416f11dc 2@news.arcor-ip.de>

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  

--

Received on Thu Oct 14 2004 - 18:55:09 CDT