Discoverer Raporlarının SQL lerini Görmek

 
SELECT *
  FROM (SELECT   obj.obj_id obj_id, obj.obj_name folder_name,
                 1 sequence_number,
                    obj.obj_object_sql1
                 || obj.obj_object_sql2
                 || obj.obj_object_sql3 sql_code
            FROM eul4_objs obj
           WHERE obj.obj_type = 'CUO' AND obj_object_sql1 IS NOT NULL
        UNION
        SELECT   seg_obj_id obj_id, obj.obj_name folder_name,
                 seg.seg_sequence sequence_number,
                    seg.seg_chunk1
                 || seg.seg_chunk2
                 || seg.seg_chunk3
                 || seg.seg_chunk4 sql_code
            FROM eul4_segments seg, eul4_objs obj
           WHERE obj.obj_type = 'CUO'
             AND obj_object_sql1 IS NULL
             AND seg.seg_obj_id = obj.obj_id
             AND seg.seg_seg_type = 1
        ORDER BY 2, 3)