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


Oracle SQL DELETE Examples

DELETE - Row

Delete a row of data. 

DELETE FROM COURSES
WHERE  COURSE_DESIGNATER = 'Java110' 
/

COMMIT WORK ;
/

DELETE - Multiple rows of data

Delete multiple rows of data. Be careful!

DELETE FROM CLASSCONVENINGS
WHERE      CLASSES_NUM_FK      > 4  
       AND CLASS_CONVENE_DATE  = TO_DATE('2006-02-15 00:00:00', 'YYYY-MM-DD HH24:MI:SS') 
       AND CLASS_LOCATION_FK   = 'Seattle-Training Room 1'

 

 



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