Using Oracle DELETE Statement The general format for the DELETE statement when using a RETURING clause is for a single table delete as shown below.
www.dba-oracle.com