1 Reply Latest reply on Jun 21, 2013 8:18 PM by meyekal

    Formatting display of a tree




      I was wondering if someone might be able to provide some help on ways to format a tree


      We want to display multiple columns of data on the same line.  For example: GOAL, METRIC, DESCRIPTION.  I wanted to see if there is a way to line the output up across the different rows, but it does not seem like our spacing options in the SQL query our being recognized


      select case when connect_by_isleaf = 1 then 0
                  when level = 1             then 1
                  else                           -1
             end as status,
             substr(RPAD(GOAL, 100, '_'),1,75) || substr(rpad(METRIC, 75, '_'),1,50) ,
             null as icon,


      Does anyone know an easy way to get similar behavior?  Using the underscore due to the fact that the space gets ignored in the output as well


      Thanks in advance for any help