Snippet Name: UPDATE Description: A sample of an update statement. Also see:» UPDATE: Update a partitioned table » UPDATE: Update based on a record » UPDATE: Update Object Table » UPDATE: with RETURNING clause » UPDATE: Nested Table Update example » UPDATE: Correlated Update » UPDATE: Update from a SELECT statement » UPDATE: based on multiple returned val... » UPDATE: Update based on a query » UPDATE: Update multiple rows » UPDATE: update a specific record » UPDATE: Single row Comment: (none) Language: Highlight Mode: PLSQL Last Modified: March 02nd, 2009
Description: A sample of an update statement.
Also see:» UPDATE: Update a partitioned table » UPDATE: Update based on a record » UPDATE: Update Object Table » UPDATE: with RETURNING clause » UPDATE: Nested Table Update example » UPDATE: Correlated Update » UPDATE: Update from a SELECT statement » UPDATE: based on multiple returned val... » UPDATE: Update based on a query » UPDATE: Update multiple rows » UPDATE: update a specific record » UPDATE: Single row
UPDATE temp_mc_bucket_details a SET (bucket1) = (SELECT bucket1 FROM temp b WHERE a.customer_id = b.customer_id AND bucket1 IS NOT NULL) WHERE customer_id IN (SELECT customer_id FROM temp WHERE bucket1 IS NOT NULL);
