|Lesson 6||Delete an entire Array or nested Table|
|Objective||Write a delete command to remove all rows from a nested table or an Array|
DELETEstatement with the
TABLEkeyword, as following example shows:
DELETE TABLE(SELECT d.detail_nest FROM SALE_HEADER d WHERE d.sale_id = 35);The DML statement above deletes all the elements from a nested table.
NULL, as the following example shows:
UPDATE SALE_HEADER SET detail_nest = NULL WHERE sale_id = 35);
NULL, which in turn deletes all the elements within the table.
DELETEstatement to delete the records from the