Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle UPDATE Statement      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: UPDATE

Definition:
The Oracle UPDATE statement is how the data in a table is altered, changed, or modified. The Oracle UPDATE statement processes one or more rows in a table and then sets one or more columns to the values you specify.

UPDATE Example:

UPDATE users
SET name = 'john';


The UPDATE statement is normally used with the WHERE clause in order to specify which rows are to have their columns changed. You do this by specifying values to be matched against one or more columns in the table. Not using a WHERE clause will result in updating all of the rows table.

This example updates only the rows in the 'users' table where the 'last_name' column contains the text 'Smith':

UPDATE users
SET first_name = 'john'
WHERE last_name = 'Smith';


Related Links:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 242 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?