Help required on updating a column text to another table column (which is a nested table)

Hello Community,

I have a requirement in my project which is as follows:

I have a table X which has object_id, text_comments as 2 columns.

Now I have other tables llike P, Q, R and S which has freezer_id, env_id, part_id and class_id respectively. Also these P, Q, R, S tables has a column named "text" which is a nested table.

like,

create table P (freezer_id, units, status, text <schema_name>.nt_text)

nested table text store as freezer_text

return as value;

and Q, R and S table has similar structure.

Requirement is, I need to update the "text" column in P, Q, R, S tables with text_comments value from table X depending on freezer_id, env_id etc.