Toad World® Forums

Nested Tables in Oracle


#1

r1.RESULT_VERSION,

FROM “OPS$PENLIMS8”.NAI_RESULTS r1, TABLE(r1.attributes) ra1

NVL (ra1.text_value, NULL) AS component_value

Thank you,
Pat Rauls

Hola!

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’


#2

Nested tables are considered an advanced feature and are not supported in the query builder.

You are actually the first person to have this need. Most data gathering and reporting don’t use nested tables or user defined objects. Is this something you would like to see as an enhancement? Or is executing in the editor sufficient?

Debbie


#3

I can live with using Editor for my nested table needs. The application I am writing SQL for uses several nested tables.

Thank you for your response!

Pat Rauls