Re: Update Table

From: Alan <alan_at_erols.com>
Date: Fri, 15 Oct 2004 12:46:59 -0400
Message-ID: <2tae5fF1uii6bU1@uni-berlin.de>

"Serdal Tanriverdi" <s.tanriverdi_at_arcor.de> wrote in message news:416f11dc_2_at_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

Very simple:

UPDATE homework
SET how_do_I_do_this =
(
SELECT Look_It_Up
FROM in_your_textbook
)
WHERE I_am_to_lazy_to_do_this_myself = 'Yes' ;

HTH Received on Fri Oct 15 2004 - 11:46:59 CDT