Does it work in SQL*Plus? : I am getting insufficient privileges when running this sql that has a nested : table in it. : Can you help me? Thank you. : ************************************** : SELECT * : FROM (SELECT KEY_ID, : MAX (DECODE (n.name, 'volume.break', n.value, null)) : "volume.break", : MAX (DECODE (n.name, 'SEGMENT_UUID', n.value, null)) "SEGMENT_UUID" : FROM metadata_tab t, TABLE(t.md_ntab) n : WHERE KEY_ID IN (SELECT KEY_ID : FROM metadata_tab T, TABLE(T.md_ntab) N : WHERE T.key_context = 'PRI' AND : T.grouping = 'Element Metadata' AND : N.name = 'PUB_CODE' AND N.value = 'FLLB' : ) AND : name IN ('volume.break', 'SEGMENT_UUID') : GROUP BY KEY_ID) : WHERE "volume.break" IS NOT NULL
|