Oracle - SQL - Delete

DELETE FROM TABLE_NAME
WHERE some_column=some_value

or 

DELETE FROM TABLE_NAME

WARNING: Deletes the entire table!!