plsql code for deleting a row from nested table in oracle 1

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>;

Here is what the above code is Doing:
1. The first SELECT statement is selecting the nested table from the parent table.
2. The second SELECT statement is selecting the rows from the nested table that you want to delete.
3. The DELETE statement is deleting the rows from the nested table.

Similar Posts