UPDATE TABLE (SELECT <table_name> FROM <parent table_name> <table alias> WHERE <clause> SET <nested table> = <variable> WHERE <clause>;
Location 1 | The UPDATE statement with the TABLE keyword |
Location 2 | The SELECT statement for selecting a particular record from the parent table |
Location 3 | The SET clause to update the value within a nested table |
Location 4 | The WHERE clause to select a particular row of the nested table |