Oracle PL/SQL: UPDATE: Update a partitioned table - Update records that exist only in a single partition.

Quick Search:

Oracle PL/SQL: UPDATE: Update a partitioned table

Jump to:

Category: >> Oracle PL/SQL >> UPDATE: Update a partitioned table

<< last

next >>

Snippet Name: UPDATE: Update a partitioned table

Description: Update records that exist only in a single partition.

Also see:
» 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

Comment: From the stanford.edu Oracle pages.

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009

UPDATE <table_name> PARTITION (<partition_name>)
SET <column_name> = <value>
WHERE <column_name> <condition> <value>;
 
 
-- The following example updates values in a single 
-- partition of the read_messages table:
 
UPDATE read_messages PARTITION (user_2153) s
   SET s.msg_id = 1
   WHERE read_date = '2009-04-01';