Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

UPDATE in Oracle

  1. Forget Code
  2. Oracle
  3. UPDATE
Update data in a column in table A based on a common column in table B 
UPDATE CATEGORIES_TEST A
SET A.PICTURE = (SELECT B.PICTURE FROM CATEGORIES B WHERE B.CATEGORY_ID = A.CATEGORY_ID)

Update data in two columns in table A based on a common column in table B. 
UPDATE CATEGORIES_TEST A
SET (A.DESCRIPTION, A.PICTURE) = (SELECT B.DESCRIPTION, B.PICTURE FROM CATEGORIES B 
                                  WHERE B.CATEGORY_ID = A.CATEGORY_ID)

Conditionally update data in table A based on a common column in table B. 
UPDATE CATEGORIES_TEST A
SET A.PICTURE = (SELECT B.PICTURE FROM CATEGORIES B WHERE B.CATEGORY_ID = A.CATEGORY_ID)
WHERE EXISTS 
( SELECT * FROM CATEGORIES B
    WHERE B.CATEGORY_ID = A.CATEGORY_ID AND B.CATEGORY_NAME = 'SEAFOOD')