FROM “OPS$PENLIMS8”.NAI_RESULTS r1, TABLE(r1.attributes) ra1
NVL (ra1.text_value, NULL) AS component_value
I can write SQL from ‘Editor’ dealing with nested tables but how do you deal with nested tables from ‘Query Builder’?
Here is the SQL I wrote:
SELECT r1.RESULT_ID,WHERE ra1.name = ‘COMPONENT’