Quick Search:
 Oracle PL/SQL: UPDATE Jump to:  
Category: >> Oracle PL/SQL >> UPDATE  

<< lastnext >>

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)

Highlight Mode: PLSQL
Last Modified: March 02nd, 2009

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);

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org