SQL> 1 select level,substr(lpad(' ',(level-1)*2,' ')||ename,1,15) ename 2 ,sal,substr(sys_connect_by_path(sal,'.'),1,50) path 3 from emp 4 start with mgr is null 5* connect by prior empno=mgr SQL> / LEVEL ENAME SAL PATH EXP_SAL ---------- --------------- ------------------------------------------------ 1 KING 5000 *5000 5000 2 JONES 2975 *5000*2975 14875000 3 SCOTT 3000 *5000*2975*3000 44625000000 4 ADAMS 1100 *5000*2975*3000*1100 -------- 3 FORD 3000 *5000*2975*3000 -------- 4 SMITH 800 *5000*2975*3000*800 -------- 2 BLAKE 2850 *5000*2850 14250000 3 ALLEN 1600 *5000*2850*1600 -------- 3 WARD 1250 *5000*2850*1250 -------- 3 MARTIN 1250 *5000*2850*1250 -------- 3 TURNER 1500 *5000*2850*1500 -------- 3 JAMES 950 *5000*2850*950 ------- 2 CLARK 2450 *5000*2450 12250000 3 MILLER 1300 *5000*2450*1300 -------- now I want that 1 record as 5000 = 5000 now I want that 2 record as 5000*2975 = 14875000 now I want that 3 record as 5000*2975*3000 =44625000000 ----------------SO ON--------------