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

<< lastnext >>

Snippet Name: UPDATE: Update multiple rows

Description: Update multiple rows in a single table based on a WHERE clause.

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 a specific record
» UPDATE: Single row
» UPDATE

Comment: (none)

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

UPDATE CLASS_LIST
SET    CLASS_TOTAL = 2
WHERE 
       CLASS_INSTRUCTOR = 'Mike Rogers' 
 
/
 
COMMIT WORK ;
/


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