--Basic DELETE

DELETE FROM [TableName]
WHERE [Condition];

--Delete Select

DELETE
FROM (SELECT *
      FROM EMPLOYEE
      WHERE DEPT_ID=1003);

-- Delete with Returning

DELETE
FROM TempEmployee
WHERE EMPL_ID = 1
RETURNING rowid INTO ReturnVal;

--Delete from partition

DELETE FROM [TableName]
PARTITION [PartitionName];
Ex:
DELETE FROM PAYROLL 
PARTITION (TaxYear2001);

--Delete from Database

DELETE
FROM [TableName]@<database_link>

Ex:

DELETE
FROM TempEmployee@HR_db;