Delete Statement

Delete Statement

Following are some typical delete statments :

REM Basic Examples

DELETE FROM temp_assign;
DELETE FROM emp
    WHERE JOB = 'SALESMAN'
    AND COMM < 100;
DELETE FROM (select * from emp)
    WHERE JOB = 'SALESMAN'
    AND COMM < 100;

REM Remote Database Example

DELETE FROM blake.accounts@dallas

REM Nested Table Example

DELETE THE(SELECT projs
           FROM dept d WHERE d.dno = 123) AS p
   WHERE p.pno IN (123, 456) OR p.budgets > 456.78;

REM Partition Example

DELETE FROM sales PARTITION (nov98)
   WHERE amount_of_sale != 0;

REM RETURNING Clause Example

DELETE FROM emp
   WHERE job = 'SALESMAN' AND COMM < 100
   RETURNING sal INTO :1;