Interactive grid removes spaces
Look at the query and result generated in sqlplus :
select plan_line_id , lpad(a.plan_operation||' '||a.plan_options, length(a.plan_operation||' '||a.plan_options)+a.plan_depth*3) OPERATION, a.plan_cost COST, output_rows "ROWS"
from gV$SQL_PLAN_MONITOR a
where sql_id ='8gan9d0z7bzhm'
looks pretty cool ;)
And the same result in grid report :
Apex 21 removes all spaces generated by lpad function. The same problem is with classic report and classic grid :( any idea why ?
K.