sql statement for update operation needed

From: Sönke Petersen <sk.petersen_at_gmx.de>
Date: Mon, 10 Mar 2003 14:04:37 +0100
Message-ID: <b4i2d2$72q$1@news.mch.sbs.de>

Hello,

I want to update an Oracle table with the contents of a second table. The tables look as follows:

systems:

---

sys_id | systemname

---

123       |     meteor
124       |     komet
125       |     jupiter
126       |     saturn
127       |     venus
128       |     sirius

nics:
===
nic_id | sys_id | name | ip_address

---

| | komet | 192.168.1.2
| | komet | 192.169.1.1.
| | jupiter | 10.123.123.1
| | venus | 10.20.30.40

The table "systems" holds the basic data. Column sys_id of table "nics" shall be updated with the appropriate data of table systems.

Can one formulate a SQL statement to do this task?

Regards,
Sönke Received on Mon Mar 10 2003 - 07:04:37 CST