Deleting nested column data

Hello community,

I have a problem. I have a table a and it has a column text value which is a nested table represented by b. I want to delete the records from table a based on text value of 'Regular' type.

Table A has following columns (object_id, text value, timestamp) and nested table b (text id, type, source)

So my delete query is

 delete from table (select t1.text value from nai_results t1, table(t1.text value) t2 where t2.type= 'Regular');

But it is not working and throwing ora-01427 error.

Please advise!

Regards,

Saurav