SQL Server Information and Resources Bookmark this page

SQLINFO.net is a Community Service from DataExpressions makers of dbOrchestra©

Google
 

 

 

 


Oracle Code Examples

SQL DML

String Functions

Stored Procedures

SQL Views

SQL Table Basics


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 ;
/

 

 



Copyright 2006-2007 by DataExpressions --- All Rights Reserved            dbOrchestra - Oracle home page