plsql code for deleting a row from nested table in oracle
snippet in sql

plsql code for deleting a row from nested table in oracle

user2231

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