Update From ....

austrian_ead · #1 (**permalink**) 01-31-03, 13:15

Hi Folks,

this time my question is easy for professionals (i hope so).

I want to update a field of a table. In SQL-Server, i would have done as following:

UPDATE taskdata t SET t.start_plan = c.start_plan
FROM view_test c
WHERE t.caseid = c.callid

This Command does the following: When t.caseid and c.callid have the same value, the value of t.start_plan is updated by c.start_plan.

Please help me, what is the right Syntax for this in Oracle.

marist89 · #2 (**permalink**) 01-31-03, 16:55

Code:

SQL> select * from xyz;

        ID TXT_DATA
---------- --------------------
         1
         2
         3
         4
         5
         6
         7
         8
         9
        10

10 rows selected.

SQL> select * from xyz_update_from;

         X TXT_UPDATE
---------- --------------------
         1  000000000001
         3  000000000003
         5  000000000005
         7  000000000007
         9  000000000009

SQL> update xyz x
  2     set txt_data = (select txt_update from xyz_update_from u where u.x = x.id)
  3* where x.id in (select x from xyz_update_from)
SQL> /

5 rows updated.

SQL> commit;

Commit complete.

SQL> select * from xyz;

        ID TXT_DATA
---------- --------------------
         1  000000000001
         2
         3  000000000003
         4
         5  000000000005
         6
         7  000000000007
         8
         9  000000000009
        10

10 rows selected.

austrian_ead · #3 (**permalink**) 01-31-03, 17:04

Perfect, that's what I needed. Thanks a lot :-)

Internet Services

Web Development

Digital Marketing

Consumer Tech