stored collections oracle pl sql code example

Example: plsql code for deleting a row from nested table in oracle

DELETE TABLE(SELECT <nested table name>
  FROM <parent table name> <table alias>
  WHERE <clause>) <nested table alias>
WHERE <clause>;