Three 0's - Simple things, simple ways ........ My personal IT Blog!!!!

Welcome to Three 0's.

Search This Blog

Wednesday, April 7, 2010

ORACLE UPDATE STATEMENT : How to modify existing rows of a table in Oracle?

UPDATE STATEMENT

UPDATE (table name) SET (field1)=(new value1), (field2)=(new value2),(field3)=(new value3),.........
where (condition check);

Example :
UPDATE EMPLOYEE_TAB
SET EMP_NAME = 'Roger Hide', EMP_LOC = 'Valencia city'
WHERE EMP_ID = 'EM22014';

No comments:

Post a Comment