Quick Search:
 Oracle PL/SQL: UPDATE: Update based on a query Jump to:  
Category: >> Oracle PL/SQL >> UPDATE: Update based on a query  

<< lastnext >>

Snippet Name: UPDATE: Update based on a query

Description: Update one or more rows based on the results of a query.

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

Comment: (none)

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

UPDATE <table_name>
SET <column_name> = (
  SELECT <column_name>
  FROM <table_name
  WHERE <column_name> <condition> <value>)
WHERE <column_name> <condition> <value>;

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