Update Specific Rows Oracle Tutorial Example

How To Update Specific Rows In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to update specific row data from a table in Oracle Database Server Tutorial Example

-- CONNECT as TUTORIAL
-- i am using sqlplus as client. you can use anything as you like.
 

   UPDATE test SET TestID=22 WHERE TestName='Michael';

      -- that's it!! TestID column of all rows of Oracle database table "test" have/has been updated
      -- whose TestName value is "Michael"

      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Update Specific Rows In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

1. How To Descending Sort/Order Data IN Oracle Database Tutorial Example
2. How To Update Data In Oracle Database Tutorial Example
3. How To Delete Specific Rows Data From Oracle Database Tutorial Example
4. How To Delete Data From Oracle Database Tutorial Example
5. How To Use COMMIT ROLLBACK In Oracle Database Tutorial Example
6. MySQL NULL Value Check Example Using PHP
7. How to Modify Column From MySQL Existing Table Example
8. Select From Multiple Database In a Query
9. 19 Examples to Learn MySQL
10. UNIX Command Example: cp - Copy file(s) or directory(ies)
11. 20 Steps to Learn CakePHP by Example