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'

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.