Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LPAD + Apex

mtJun 21 2022

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)

Comments
Post Details
Added on Jun 21 2022
2 comments
119 views