Is there a way to retain the lpad spacing from this query, in an Apex classic report? (from Welcome To Oracle blog); or an alternative way to achieve the same result?
select empno,lpad(' ',level*3,' ')||ename name,
mgr, prior ename, level
from emp
connect by prior empno = mgr
start with mgr is null;
thank you - mt in ny (yes, I've tried ot change my profile)