1 Reply Latest reply: Jun 21, 2013 3:18 PM by meyekal RSS

    Formatting display of a tree

    meyekal

      Hello,

       

      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,
             level,
             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