Misc Oracle SQL UPDATE Examples
UPDATE - Single row
Update a single row of data.
UPDATE STUDENTS
SET
EMPLOYEE_ID_FK = '3789' ,
GENDER_CODE = 'F' ,
MARITAL_STATUS_CODE = 'M'
WHERE STUDENT_ID = 11
/
COMMIT WORK ;
/
UPDATE - Update multiple rows
Update multiple rows of data..
UPDATE CLASSCONVENINGS
SET ACITVE_FLG = 2
WHERE
CLASS_CONVENE_DATE = TO_DATE('2005-12-31 00:00:00',
'YYYY-MM-DD HH24:MI:SS')
/
COMMIT WORK ;
/
If you find this site useful and are a book buyer/reader...
You can support my site by clicking on one of the Links below to Abe books
By doing this, I will receive a small commision on your purchase and making your purchase
will not cost you any more money than if you went directly the site yourself!
Abe Books sells books at a fraction of the original cost. I
have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars
including shipping costs
Click on applicable icon to find books at Abe Books on ...
|
| Oracle 8i and 9i |
Oracle 10g |
PL/SQL |
|
|
|
|
|
Abe Books is one of my affiliates. I only use affiliates that I also
purchase products from. I love Abe books. If it is printed they likely
have a copy. I have also included a generic link to Abe Books below.
Once on their site, you will find that they have a nice, easy to use search engine so
to find what you are looking for. |

|